| From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | That was easy |
| Date: | 2008-10-02 03:13:40 |
| Message-ID: | 0836165E8EE50F40A3DD8F0D871372670127BDAA@azsmsx421.amr.corp.intel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-10-02 07:31:33 | Re: That was easy |
| Previous Message | Darragh Gammell | 2008-10-02 01:39:54 | Re: tsearch2 Upgrade to 8.3 tsearch2.so errors |