duplicating a postgresql DB

23 Aug

e.g. for testing purposes before touching valuable data… set the DB names ORIG_DB=“orig_db_name” NEW_DB=“new_db_name” create a dump (make sure to use a user having access rights to the db) TSTAMP=$(date +%F_%H-%M) FILE_ORIG=”${ORIG_DB}_${TSTAMP}.sql” pg_dump -f ${FILE_ORIG} —blobs —create ${ORIG_DB} adjust the … Read More »

backup / sync

25 Oct

have a look: http://www.linux-mag.com/id/7881 http://www.pro-linux.de/NB3/artikel/2/1183/uebersichtliche-auflistung-der-optionen-zur-wiederherstellung-von-daten.html http://mikerubel.org/computers/rsync_snapshots/index.html http://www.sparkleshare.org/

TSM and pathnames

10 Feb

wow, note this difference: /opt/tivoli/tsm/client/ba/bin/dsmc incr /home/backups/ . . Total number of objects inspected: 2.314 . . Elapsed processing time: 00:00:01 and the same command without the trailing slash: /opt/tivoli/tsm/client/ba/bin/dsmc incr /home/backups . . Total number of objects inspected: 32.378 … Read More »