| From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
|---|---|
| To: | Bjørn T Johansen <btj(at)havleik(dot)no> |
| Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Moving from 7.3.4 to 7.4.x? |
| Date: | 2004-03-10 15:52:12 |
| Message-ID: | 404F39AC.1040401@potentialtech.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bjørn T Johansen wrote:
> I am running 7.3.4 and I am thinking about upgrading to 7.4, so I was
> just wondering what pitfalls, caveats,etc I should know of?
I recently upgraded a production system from 7.3 to 7.4 on FreeBSD.
I used pg_dump to back up all my databases, uninstalled 7.3, deleted
the data directory, installed 7.4, ran initdb, tweaked postgres.conf,
restored the data from the dump and TADA! everything was running
just fine.
Your mileage may vary, but it worked very nicely for me. The entire
process took less than an hour, but the database is pretty small.
As a precaution, I had a binary package of 7.3 ready to reinstall in
case the 7.4 didn't take, but I didn't need it.
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-03-10 15:54:46 | Re: postgres FROM clause problem |
| Previous Message | Dexter Tad-y | 2004-03-10 15:51:45 | Re: [NEWBIE] need help optimizing this query |