Re: postgres 8.2 doesn't start after ubuntu upgrade

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(at)djs-consulting(dot)com <mailto:daniel(at)djs-consulting(dot)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++++