| From: | "Michael Schmidt" <michaelmschmidt(at)msn(dot)com> |
|---|---|
| To: | "PostgreSQL General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: programatic database dump |
| Date: | 2006-04-07 01:03:48 |
| Message-ID: | BAY101-DAV28C0DB02106FE1E2DAA0DA3C90@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've been working on this issue lately. There is quite a bit more to a database than the tables (e.g., functions), and I'm not sure how you would go about getting a backup of the entire database through SQL. I've been working on a Java class to do the dump and restore. It doesn't look terribly hard.
However, having said that, I wonder if someone could answer something. How do pg_dump and pg_restore use stdout and stderr? I saw a very old post that indicated -v caused all output to go to stderr. I couldn't find anything recent and nothing in the manual.
Thanks!
Michael Schmidt
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2006-04-07 01:52:14 | Re: stored proc vs sql query string |
| Previous Message | Chris | 2006-04-07 00:54:06 | Re: Debian package for freeradius_postgresql module |