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