From: Daniel J. Summers <daniel@djs-consulting.com>
To: pgsql-admin@postgresql.org
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
Date: Sat, 28 Feb 2009 19:54:20 -0700
Message-ID: <49A9F8DC.2080309@djs-consulting.com> (raw)
In-Reply-To: <1386.71.208.251.23.1235868684.squirrel@ideotrope.org>
References: <1386.71.208.251.23.1235868684.squirrel@ideotrope.org>
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++++
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: daniel@djs-consulting.com
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
In-Reply-To: <49A9F8DC.2080309@djs-consulting.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox