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@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@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 :)
Tory