| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Tim Penhey <tim(at)penhey(dot)net> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Backup and Restore of PostgreSQL |
| Date: | 2004-06-07 10:39:53 |
| Message-ID: | 40C445F9.5010402@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Együd Csaba | 2004-06-07 11:36:41 | Re: pg_dump, bytea, dump order questions |
| Previous Message | Albretch | 2004-06-07 10:34:58 | Re: CREATE DATABASE on the heap with PostgreSQL? |