|
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!
|
