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 1RPSgt-0000io-K6 for garchives@archives.gentoo.org; Sun, 13 Nov 2011 05:33:15 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 8810E21C071; Sun, 13 Nov 2011 05:32:59 +0000 (UTC) Received: from smtprelay.b.hostedemail.com (smtprelay0104.b.hostedemail.com [64.98.42.104]) by pigeon.gentoo.org (Postfix) with ESMTP id 2C4FB21C028 for ; Sun, 13 Nov 2011 05:32:00 +0000 (UTC) Received: from filter.hostedemail.com (b-bigip1 [10.5.19.254]) by smtprelay05.b.hostedemail.com (Postfix) with SMTP id C2AFB29CE16D for ; Sun, 13 Nov 2011 05:31:59 +0000 (UTC) X-Panda: scanned! X-Session-Marker: 67656F726765406D757475616C646174612E636F6D X-Filterd-Recvd-Size: 1826 Received: from brego.pewamo.office (unknown [69.63.237.121]) (Authenticated sender: george@mutualdata.com) by omf02.b.hostedemail.com (Postfix) with ESMTP for ; Sun, 13 Nov 2011 05:31:59 +0000 (UTC) Received: by brego.pewamo.office (Postfix, from userid 500) id E4611E3E56; Sun, 13 Nov 2011 00:31:58 -0500 (EST) Date: Sun, 13 Nov 2011 00:31:58 -0500 From: Michael George To: gentoo-user@lists.gentoo.org Subject: [gentoo-user] pg_upgrade from 9.0.5 to 9.1.1 Message-ID: <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 User-Agent: Mutt/1.5.21 (2010-09-15) X-Archives-Salt: de99caa3-a46f-42ce-b600-2dbf7429803a X-Archives-Hash: 6bb4df797f428ecc21fc4836d15250fd 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? -- -Michael Rident stolidi verba Latina. -Ovid