[Planetlab-devel] upgrading from 8.1 to 8.2 postgresql

[Marc Fiuczynski]

Hello Baris,

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  
information.

There apparently is other stuff that needs to be wiped out / fixed.

Marc

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
> follows:
>
> /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
> /var/lib/pgsql/backups/planetlab5.2009-10-15-16-57-45.sql
> /var/lib/pgsql/backups/drupal.2009-10-15-16-57-45.sql
>
> 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  
>> succeeded
>> 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  
>> '\''BLANKED_OUT'\'''
>> template1
>> psql: FATAL:  Ident authentication failed for user "postgres"
>>
>> Any suggestions?
>>
>> Marc
>>
>> _______________________________________________
>> Devel mailing list
>> Devel at lists.planet-lab.org
>> https://lists.planet-lab.org/mailman/listinfo/devel
>>
>
>
>
> -- 
> Baris
>
> _______________________________________________
> Devel mailing list
> Devel at lists.planet-lab.org
> https://lists.planet-lab.org/mailman/listinfo/devel