Re: backup and recovery problem

On 25/08/2009 8:12 PM, chanda roopesh wrote:
> Hi,
>
> i want to know is there any automated backup and recovery process for
> postgres 8.3 if not can you suggest me how to handle on Windows Server
> 2003 and Linux.

Linux: pg_dump and cron (or ideally your existing backup scheduler via
an external command)

Windows: pg_dump via your existing backup software's ability to run a
command before the backup. If it can't do that, get better backup software.

Also look into PITR / WAL shipping (see the manual and Google). If you
rely on these, TEST YOUR BACKUPS! They're solid, but only if you get the
setup right, and there ARE mistakes you can make.

Note that you MUST NOT use pg_start_backup and pg_stop_backup for file
system copies unless you have WAL archiving in place or have scripts to
copy the required WAL archives after pg_stop_backup.

--
Craig Ringer