Travis Smith wrote:
There are tools that allow you to reverse engineer schemas.. or to generate
ERD's .. visio comes to mind. It works on odbc connections.
Schema Spy is a slick tool and is free. Works well with postgres. You
can find it at source forge:
We have 8.1.3 on our operational and development database servers and
will upgrade to 8.3.3 (development) and 8.2.9 (operations) soon. (We
will not upgrade both systems' databases now because we've already
tested 8.2 on our web server database for the past year, so it's already
spent time in
I backed up all my databases using:
pg_dumpall -O -c -U postgres /tmp/pgalldb2
-O to remove owners on all objects
-c to drop databases before recreating them during the restore to prevent
duplicate records
I restored all the databases with this command
psql -U postgres -f /tmp/pgalldb2 postgres
On Thu, 2008-07-24 at 10:20 -0700, Marc Fromm wrote:
I backed up all my databases using:
pg_dumpall -O -c -U postgres /tmp/pgalldb2
-O to remove owners on all objects
-c to drop databases before recreating them during the restore to
prevent duplicate records
I restored all the databases
On Thu, Jul 24, 2008 at 9:00 AM, Chris Bovitz
[EMAIL PROTECTED] wrote:
We have 8.1.3 on our operational and development database servers and will
upgrade to 8.3.3 (development) and 8.2.9 (operations) soon. (We will not
upgrade both systems' databases now because we've already tested 8.2 on our
If I restore all the postgresql databases from pg_dumpall and use the -c to
drop databases before restoring them the size of the base directory
dramatically increases with each restore (193MB to 355MB to 624MB). If I run
vacuumdb, it only drops by a few MB.
If I do the long process by:
1.
Scott Marlowe wrote:
On Thu, Jul 24, 2008 at 9:00 AM, Chris Bovitz
[EMAIL PROTECTED] wrote:
We have 8.1.3 on our operational and development database servers and will
upgrade to 8.3.3 (development) and 8.2.9 (operations) soon. (We will not
upgrade both systems' databases now
On Thu, Jul 24, 2008 at 1:51 PM, Chris Bovitz
[EMAIL PROTECTED] wrote:
Does it matter which version - 8.3.3 or 8.2.9 - we install on our client
boxes? Is the client-side backwards compatible? Or should we install both
and have a wrapper for the psql script to detect which database we're