From: Scott Marlowe <scott.marlowe@gmail.com>
To: Daniel J. Summers <daniel@djs-consulting.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
Date: Sat, 28 Feb 2009 20:56:43 -0700
Message-ID: <dcc563d10902281956s74a74c39k2d8c309d416544d7@mail.gmail.com> (raw)
In-Reply-To: <49A9F8DC.2080309@djs-consulting.com>
References: <1386.71.208.251.23.1235868684.squirrel@ideotrope.org>
<49A9F8DC.2080309@djs-consulting.com>
On Sat, Feb 28, 2009 at 7:54 PM, Daniel J. Summers
<daniel@djs-consulting.com> wrote:
> 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.
You're absolutely right. FYI, pg has a different numbering system
where the first two digits are pretty much both major numbers. 8.4
and 8.3 are two distinct major versions, and are not binary on disc
compatible etc. That means that 8.2 and 8.1 were as different as 8.0
and 7.4 in terms of things like file formatting and catalogues
And pg_upgradescluster is a great little bit of code. I wish RedHat
had such things. (If they do someone please tell me.)
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: scott.marlowe@gmail.com, daniel@djs-consulting.com
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
In-Reply-To: <dcc563d10902281956s74a74c39k2d8c309d416544d7@mail.gmail.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