On Wed, Jul 18, 2007 at 03:39:01PM +0530, Ashish Karalkar wrote: > 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 >
Can you use ssh? For example: ssh -x nirmalvihar.info pg_dump -F c ppx > `date +%Y%m%d` -- Make April 15 just another day, visit http://fairtax.org ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match