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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
