Tory M Blue wrote: > >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
That sure looks like a tablespace to me, not a data directory. > > /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 :) You are using an 8.4.4 psql to connect to a 9.1.1 server. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
