Re: [GENERAL] Backup and Restore of PostgreSQL

2004-06-07 Thread Lincoln Yeoh
Well you might want to make sure the servlet only does one pg_dump at a time to a particular file in a secured directory (making sure you don't have any funny symlink problems) and all that sort of boring security, reliability and predictability stuff. Don't forget the UI. The dump could take a

Re: [GENERAL] Backup and Restore of PostgreSQL

2004-06-07 Thread Campano, Troy
9:57 AM To: Tim Penhey Cc: pgsql-general Subject: Re: [GENERAL] Backup and Restore of PostgreSQL Tim Penhey wrote: > Richard Huxton mentioned: > >> >>The pg_dump utility is the standard way to backup PostgreSQL and the >>custom format is already compressed. > The quest

[GENERAL] Backup and Restore of PostgreSQL

2004-06-04 Thread Tim Penhey
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 d