Home > mailing lists

pg_dump - Mailing list pgsql-admin

From	Nirav Parikh
Subject	pg_dump
Date	October 10, 2005 05:27:02
Msg-id	221385EC3F18A44DB0925467A1D2395F38F8D9@exsrv3.workskillsprofessionals.com.au Whole thread Raw
Responses	Re: pg_dump
List	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

From: lorid
Date: 08 October 2005, 01:02:26
Subject: Re: How do I unsubscribe?

From: Luca Ferrari
Date: 10 October 2005, 06:33:25
Subject: character problem