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...
Read more »

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 »