Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 937D214518E5 for ; Thu, 8 Dec 2011 16:15:05 -0400 (AST) Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RYkMz-0002KZ-8k for pgsql-performance@postgresql.org; Thu, 08 Dec 2011 20:15:05 +0000 Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id pB8KEq616142; Thu, 8 Dec 2011 15:14:52 -0500 (EST) From: Bruce Momjian Message-Id: <201112082014.pB8KEq616142@momjian.us> Subject: Re: pg_upgrade In-Reply-To: To: Tory M Blue Date: Thu, 8 Dec 2011 15:14:52 -0500 (EST) CC: pgsql-performance@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Pg-Spam-Score: -3.1 (---) X-Archive-Number: 201112/76 X-Sequence-Number: 45875 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 http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +