Re: redirecting output of pg_dump

From: Joshua N Pritikin <jpritikin(at)pobox(dot)com>
To: Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: redirecting output of pg_dump
Date: 2007-07-18 10:18:56
Message-ID: 20070718101856.GG4819@always.joy.eth.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jayakumar_Mukundaraju 2007-07-18 10:31:02 Re: redirecting output of pg_dump
Previous Message Ashish Karalkar 2007-07-18 10:09:01 redirecting output of pg_dump