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 large databases. 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's try to be at least somewhat objective. Igor Neyman -----Original Message----- From: Gauthier, Dave [mailto:dave.gauthier@xxxxxxxxx] Sent: Wednesday, October 01, 2008 11:14 PM To: pgsql-general@xxxxxxxxxxxxxx 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_dumpall and 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... FIRST TRY !!! 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!
