Thread: 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!
Gauthier, Dave wrote: > That was far and away the easiest DB upgrade I ever did. It was fast > and 100% clean. Shh! Some of us try to make a living supporting PG ;-) -- Richard Huxton Archonet Ltd
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!