From: Markus Wanner <markus@bluegap.ch>
To: Bryan Keith <bryan@ideotrope.org>
Cc: pgsql-admin@postgresql.org, Scott Marlowe <scott.marlowe@gmail.com>
Cc: Daniel J. Summers <daniel@djs-consulting.com>
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
Date: Mon, 02 Mar 2009 09:11:21 +0100
Message-ID: <49AB94A9.1060907@bluegap.ch> (raw)
In-Reply-To: <1248.71.208.251.23.1235955413.squirrel@ideotrope.org>
References: <1386.71.208.251.23.1235868684.squirrel@ideotrope.org>
<49A9F8DC.2080309@djs-consulting.com>
<dcc563d10902281956s74a74c39k2d8c309d416544d7@mail.gmail.com>
<1237.71.208.251.23.1235882478.squirrel@ideotrope.org>
<1168.71.208.251.23.1235918386.squirrel@ideotrope.org>
<49AB05D4.8060309@bluegap.ch>
<1248.71.208.251.23.1235955413.squirrel@ideotrope.org>
Hi,
Bryan Keith wrote:
> How can I install postgres 8.2 without messing up the data in
> /var/lib/postgresql/8.2/main?
The way Postgres packages for Debian (and Ubuntu) are built, that's no
problem. Just install postgresql-8.2 again. After the upgrade, you can
remove the package and the data directory (after having made sure you
don't need it anymore).
> Can I just copy that to a new location and copy it back after the
> installation? Or...?
Not necessarily required, but having a backup is always a good thing.
> How do I install postgres 8.2? I think I installed 8.2 with something
> like sudo apt-get install postgresql, but that will install 8.3 now, I
> think.
Try: sudo apt-get install postgresql-8.2
I'm not sure about Ubuntu. Probably 8.2 isn't included in Intrepid
anymore. (packages.ubuntu.com is currently not responding) (Why don't
you stay at a LTS ubuntu version for a database server?)
If that's the case, try adding the Hardy Heron repository back to
/etc/apt/sources.list. If postgres-8.2 isn't available on Intrepid Ibex,
it then falls back to that from Hardy Heron.
After having installed that, you should be able to access your Postgres
8.2 data again. You can then do a dump/restore cycle to migrate from 8.2
to 8.3. You might want to check out pg_upgradecluster for that.
Good Luck
Markus Wanner
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: markus@bluegap.ch, bryan@ideotrope.org, scott.marlowe@gmail.com, daniel@djs-consulting.com
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade
In-Reply-To: <49AB94A9.1060907@bluegap.ch>
* 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