From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1RPSqO-0002BP-54 for garchives@archives.gentoo.org; Sun, 13 Nov 2011 05:43:04 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 1897D21C162; Sun, 13 Nov 2011 05:42:51 +0000 (UTC) Received: from smtprelay.b.hostedemail.com (smtprelay0174.b.hostedemail.com [64.98.42.174]) by pigeon.gentoo.org (Postfix) with ESMTP id 7A3A221C094 for ; Sun, 13 Nov 2011 05:41:14 +0000 (UTC) Received: from filter.hostedemail.com (b-bigip1 [10.5.19.254]) by smtprelay03.b.hostedemail.com (Postfix) with SMTP id 007D05B34DF6 for ; Sun, 13 Nov 2011 05:41:14 +0000 (UTC) X-Panda: scanned! X-Session-Marker: 67656F726765406D757475616C646174612E636F6D X-Filterd-Recvd-Size: 2319 Received: from brego.pewamo.office (unknown [69.63.237.121]) (Authenticated sender: george@mutualdata.com) by omf13.b.hostedemail.com (Postfix) with ESMTP for ; Sun, 13 Nov 2011 05:41:13 +0000 (UTC) Received: by brego.pewamo.office (Postfix, from userid 500) id 36EC1E3E56; Sun, 13 Nov 2011 00:41:13 -0500 (EST) Date: Sun, 13 Nov 2011 00:41:13 -0500 From: Michael George To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] pg_upgrade from 9.0.5 to 9.1.1 Message-ID: <20111113054113.GA26181@brego.pewamo.office> References: <20111113053158.GA24608@brego.pewamo.office> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20111113053158.GA24608@brego.pewamo.office> User-Agent: Mutt/1.5.21 (2010-09-15) X-Archives-Salt: 20d3eee2-ebc8-4a44-b6b3-d1f7f4804a5a X-Archives-Hash: 74da4497686939b41cec8982b369b892 On Sun, Nov 13, 2011 at 12:31:58AM -0500, Michael George wrote: > I am trying to upgrade my postgresql server from 9.0 to 9.1. I've > installed 9.1.1 and used eselect to make it the slot to run for the > system. > > When I run: > pg_upgrade -v --check -d /var/lib/postgresql/9.0/data -D \ > /var/lib/postgresql/9.1/data -b /usr/lib64/postgresql-9.0/bin -B \ > /usr/lib64/postgresql-9.1/bin > > I get: > Running in verbose mode > Performing Consistency Checks > ----------------------------- > Checking current, bin, and data directories ok > Checking cluster versions ok > "/usr/lib64/postgresql-9.0/bin/pg_ctl" -w -l "/dev/null" -D > "/var/lib/postgresql/9.0/data" -o "-p 5432 -c autovacuum=off -c > autovacuum_freeze_max_age=2000000000" start >> "/dev/null" 2>&1 > > When I run that command manually and send the output to a logfile, it > appears that it's trying to find postgresql's *.conf files in the data > directory rather than in /etc/postgresql-9.0. I don't see a way to > specify the location of the conf files separate from the data files. > > How do I proceed? According to: http://archives.postgresql.org/pgsql-hackers/2011-09/msg01482.php The normal workaround is to make symlinks and delete them after the pg_upgrade. It appears they might implement a solution, but it isn't in place for 9.1. :( -- -M Rident stolidi verba Latina. -Ovid