pg_dump

From: "Nirav Parikh" <nirav(dot)p(at)workskillsprofessionals(dot)com(dot)au>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump
Date: 2005-10-10 05:30:07
Message-ID: 221385EC3F18A44DB0925467A1D2395F38F8D9@exsrv3.workskillsprofessionals.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am trying to write cronjob so it will backup database everynight on
another machine.
Currently is doing it on the same machine with this script.

20 13 * * * pg_dump -F c -f /root/database.pgdump database

How can I send it to different machine. Machine IP address is
192.168.1.13

Is it possible to write pg_restore job ones it finishes dumping on that
machine?

Does anybody know how to do this?

Thanks in Advance.

Regards,

Neo

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Luca Ferrari 2005-10-10 06:48:59 Re: pg_dump
Previous Message Luca Ferrari 2005-10-09 12:43:24 character problem