Skip site navigation (1) Skip section navigation (2)

Re: pg_upgrade

From: Tory M Blue <tmblue(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: pg_upgrade
Date: 2011-12-07 20:13:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
From my last report I had success but it was successful due to lots of
manual steps. I figured it may be safer to just create a new rpm,
installing to pgsql9 specific directories and a new data directory.

This allows pg_upgrade to complete successfully (so it says). However
my new data directory is empty and the old data directory now has what
appears to be 8.4 data and the 9.1 data.

/data is olddatadir original data dir

[root(at)devqdb03 queue]# ll /data/queue
total 12
drwx------ 2 postgres dba 4096 2011-12-07 09:44 16384
drwx------ 3 postgres dba 4096 2011-12-07 11:34 PG_9.1_201105231
-rw------- 1 postgres dba    4 2011-12-07 09:44 PG_VERSION

/data1 is the new 9.1 installed location.
[root(at)devqdb03 queue]# ll /data1/queue/
total 0

Do I have to manually move the new PG_9.1..... data to /data1 or. I'm
just confused at what I'm looking at here.

If I don't move anything and start up the DB , I get this

psql (8.4.4, server 9.1.1)
WARNING: psql version 8.4, server version 9.1.
         Some psql features might not work.
Type "help" for help.

Sorry my upgrade process has been an ugly mess :)


In response to

  • pg_upgrade at 2011-12-03 04:09:25 from Tory M Blue


pgsql-performance by date

Next:From: Scott MarloweDate: 2011-12-07 20:19:29
Subject: Re: autovacuum, any log?
Previous:From: Anibal David AcostaDate: 2011-12-07 15:34:30
Subject: autovacuum, any log?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group