Re: redirecting output of pg_dump - Mailing list pgsql-general

From Joshua N Pritikin
Subject Re: redirecting output of pg_dump
Date
Msg-id 20070718101856.GG4819@always.joy.eth.net
Whole thread Raw
In response to redirecting output of pg_dump  ("Ashish Karalkar" <ashish.karalkar@info-spectrum.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Ashish Karalkar"
Date:
Subject: redirecting output of pg_dump
Next
From: "A. Kretschmer"
Date:
Subject: Re: redirecting output of pg_dump