am Wed, dem 18.07.2007, um 15:39:01 +0530 mailte Ashish Karalkar folgendes: > Hello all, > > I want to take backup from one server and save it to another machine hard > drive. > The backup will be taken through a shell script attached to a cron job. > > something like: > > pg_dump -d postgres -U postgres -f <IP address of other machine and path to > save the file on that machine > > > is there any way?
Yes, any. For instance: - you are on the remote machine (which should store the backup) ssh remote "pg_dump ..." > backup.sql - you have the pg_dump installed on the backup-machine: pg_dump -h remote ... > backup.sql - you are on the server: pg_dump ... | ssh backup_server "cat - > backup.sql" (all untested, but should work) Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
