[Planetlab-devel] upgrading from 8.1 to 8.2 postgresql

[Barış Metin]

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