Re: Backup and Restore of PostgreSQL

Tim Penhey wrote:
> Hi All,
>
> I have a java web server (Tomcat) running a web application that uses PostgreSQL for all
> of the data.  All of the management of the application is done through the web application
> and I would like to provide a backup and restore option for the user.  Backup would
> somehow get all of the data/schema (maybe not schema) from the DB and zip it and send it
> to the customer through the web-app to allow them to save the backup on their local
> machine.  They could then select this backup file to restore the DB to the state that it
> was when the backup was taken.

The pg_dump utility is the standard way to backup PostgreSQL and the
custom format is already compressed.

--
   Richard Huxton
   Archonet Ltd