It's strange that you decided to make comparison to Oracle on this particular matter.
Oracle doesn't require during upgrades exporting all the data from the database and then importing - Oracle does
upgrades"in-place", while with PG you can't upgrade without dump/restore. And this becomes a problem (in PG) with
largedatabases.
I'm not trying to start enother "war" compairing one DBMS to another (I have experience with both).
But, trashing Oracle that I'm seeing here lately, looks at least naïve - each db has it's advantages/disadvantages, but
let'stry to be at least somewhat objective.
Igor Neyman
-----Original Message-----
From: Gauthier, Dave [mailto:dave.gauthier@intel.com]
Sent: Wednesday, October 01, 2008 11:14 PM
To: pgsql-general@postgresql.org
Subject: That was easy
I just ported my whole DB instance, 4 db's inside with roles, triggers, stored procedures, etc... from v8.2.5 to
v8.3.4.After the initdb, I mimiced the mods I had in the postgres.conf and pg_hba.conf files to v83. Then I used
pg_dumpalland psql to do the move. That was far and away the easiest DB upgrade I ever did. It was fast and 100%
clean. Everything worked including remote attaches, all the perl/DBI scripts, even the odbc stuff on Windows worked...
FIRSTTRY !!! I really don't miss the bad-ole days trying to do someting like this with Oracle.
Not many posts here are written to say "Great Job Guys". This one is. Thanks!