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!
