Re: database backup

At 10:42 PM 7/6/2002, Darren Ferguson wrote:
>If you are using a Unix environment then you should use cron and then
>pg_dump in order to produce a complete backup of the database.
>
>See the pg_dump --help for complete list of commands
>
>Then the shell script in the cron job can call pg_dump with the relevant
>options

If you want to "incrementalize" it, you could always keep a base, and diff 
the new dump against it, and store just the diff.

Be sure to run the output through bzip2 (or gzip -9) to save space.

Cheers,

Doug