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!

  

Reply via email to