[Planetlab-devel] upgrading from 8.1 to 8.2 postgresql
mef at CS.Princeton.EDU
Thu Oct 15 18:22:17 EDT 2009
I've followed these instructions and when I get to the "service
postgresql start" after the upgrade I get:
An old version of the database format was found.
You need to upgrade the data format before using PostgreSQL.
See /usr/share/doc/postgresql-8.2.14/README.rpm-dist for more
There apparently is other stuff that needs to be wiped out / fixed.
On Oct 15, 2009, at 9:25 AM, Barış Metin wrote:
> Hi Marc,
> I tried this one yesterday but didn't have time to test if everything
> was fine until now. The procedure to dump/restore the database goes as
> /etc/plc.d/db dump
> dropdb -U postgres planetlab5
> dropdb -U postgres drupal
> service plc stop
> # upgrage postgresql (8.1 to 8.2)
> service postgresql start
> createdb -U postgres --encoding=UNICODE --owner=pgsqluser planetlab5
> createdb -U postgres --encoding=UNICODE --owner=pgsqluser drupal
> /etc/plc.d/db restore
> service postgresql stop
> service plc start
> This seems to work fine in my test setup.
> On Thu, Oct 15, 2009 at 4:22 PM, Marc Fiuczynski
> <mef at cs.princeton.edu> wrote:
>> Hi Baris,
>> I just thought I'd give the 8.1 to 8.2 upgrade a shot. I've not
>> yet, but here are my steps:
>> /etc/plc.d/db dump
>> service plc stop
>> service postgresql stop
>> #run my 8.1-to-8.2 rpm upgrade
>> Now when I try to start postgresql it complains about there being
>> an old
>> database format. Since I've dumped the data, I guessed it was ok
>> to remove
>> (or move) /var/lib/pgsql/data followed by running:
>> service postgresql initdb
>> service postgresql start
>> At this point I was hoping I could either restore the dumped
>> databases, but
>> was getting errors wrt pgsqluser authentication not working.
>> So I manually ran "/etc/plc.d/postgresql start", but this doesn't
>> do the
>> trick either.
>> psql -U pgsqluser -c '' template1
>> + psql -U postgres -c 'CREATE USER pgsqluser PASSWORD
>> psql: FATAL: Ident authentication failed for user "postgres"
>> Any suggestions?
>> Devel mailing list
>> Devel at lists.planet-lab.org
> Devel mailing list
> Devel at lists.planet-lab.org
More information about the Devel