Re: postgres 8.2 doesn't start after ubuntu upgrade - Mailing list pgsql-admin

From Daniel J. Summers
Subject Re: postgres 8.2 doesn't start after ubuntu upgrade
Date
Msg-id 49A9F8DC.2080309@djs-consulting.com
Whole thread Raw
In response to postgres 8.2 doesn't start after ubuntu upgrade  ("Bryan Keith" <bryan@ideotrope.org>)
Responses Re: postgres 8.2 doesn't start after ubuntu upgrade
List pgsql-admin
Bryan Keith wrote:
> I can run 8.3 and see the dbs (the default ones only; not mine) with psql.
>
I ran into this on an upgrade - however, I didn't do what I'm about to
describe, and I lost all my data. Luckily, it wasn't the only place
where it was, but there was some development stuff that I had to
reaccomplish. Once I had lost it, I discovered the command below...

The command you're looking for is pg_upgradecluster. There's a
description of it at
http://manpages.ubuntu.com/manpages/hardy/man8/pg_upgradecluster.8.html
. I believe the only time you'll need this is if you change the major or
minor version - for 8.3.5 to 8.3.6, for example, I believe there's no
upgrade required.

--
Daniel J. Summers
*Owner, DJS Consulting* Support <http://support.djs-consulting.com/> •
Tech Blog <http://www.djs-consulting.com/linux/blog>

daniel@djs-consulting.com <mailto:daniel@djs-consulting.com> •
http://www.djs-consulting.com <http://www.djs-consulting.com/>

GEEKCODE 3.12 GCS/IT d s-:+ a C++ L++ E--- W++ N++ o? K- w !O M--
V PS+ PE++ Y? !PGP t+ 5? X+ R* tv b+ DI++ D+ G- e h---- r+++ y++++

pgsql-admin by date:

Previous
From: "Bryan Keith"
Date:
Subject: postgres 8.2 doesn't start after ubuntu upgrade
Next
From: Scott Marlowe
Date:
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade