Re: Backup and Restore of PostgreSQL

Richard Huxton mentioned:
>
> 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

The question though is how to call this from a java servlet / hopefully in a OS
independant way.

Tim