| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Backup and Restore of PostgreSQL |
| Date: | 2004-06-07 17:00:35 |
| Message-ID: | 5.2.1.1.1.20040608005637.02e36af8@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 while.
At 11:27 AM 6/7/2004 -0400, Campano, Troy wrote:
>Easiest thing to do is to call pgsql from your servlet, have it dump the
>file somewhere in your web apps directory, and then either send the link
>to that file to the client or automatically forward the client there.
>
>Option 2 would be to use JDBC to view the meta data of the table and use
>it to write "CREATE" statements, and then build inserts from this data,
>but this would be very time consuming and difficult to do.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lincoln Yeoh | 2004-06-07 17:04:00 | Re: Index question |
| Previous Message | Teodor Sigaev | 2004-06-07 16:52:05 | Re: Tsearch case sensitive with dotted search terms. |