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