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 1RPSpL-00020a-Gd for garchives@archives.gentoo.org; Sun, 13 Nov 2011 05:41:59 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 89C6521C0C3; Sun, 13 Nov 2011 05:41:40 +0000 (UTC) Received: from svr-us4.tirtonadi.com (svr-us4.tirtonadi.com [69.65.43.212]) by pigeon.gentoo.org (Postfix) with ESMTP id 86C5E21C029 for ; Sun, 13 Nov 2011 05:40:38 +0000 (UTC) Received: from mail-bw0-f53.google.com ([209.85.214.53]) by svr-us4.tirtonadi.com with esmtpsa (TLSv1:RC4-SHA:128) (Exim 4.69) (envelope-from ) id 1RPSo2-000EUQ-31 for gentoo-user@lists.gentoo.org; Sun, 13 Nov 2011 12:40:38 +0700 Received: by bkaq10 with SMTP id q10so5976132bka.40 for ; Sat, 12 Nov 2011 21:40:34 -0800 (PST) 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 Received: by 10.204.155.152 with SMTP id s24mr14139803bkw.5.1321162834560; Sat, 12 Nov 2011 21:40:34 -0800 (PST) Received: by 10.223.74.16 with HTTP; Sat, 12 Nov 2011 21:40:34 -0800 (PST) Received: by 10.223.74.16 with HTTP; Sat, 12 Nov 2011 21:40:34 -0800 (PST) In-Reply-To: <20111113053158.GA24608@brego.pewamo.office> References: <20111113053158.GA24608@brego.pewamo.office> Date: Sun, 13 Nov 2011 12:40:34 +0700 Message-ID: Subject: Re: [gentoo-user] pg_upgrade from 9.0.5 to 9.1.1 From: Pandu Poluan To: gentoo-user@lists.gentoo.org Content-Type: multipart/alternative; boundary=000e0ce02e2671c58604b19731a1 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - svr-us4.tirtonadi.com X-AntiAbuse: Original Domain - lists.gentoo.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - poluan.info X-Archives-Salt: 7f7e5fb0-3932-46e6-93ca-aba6a022e9eb X-Archives-Hash: 9d7f6a9c5e1edaa9096587874275804a --000e0ce02e2671c58604b19731a1 Content-Type: text/plain; charset=UTF-8 On Nov 13, 2011 12:35 PM, "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? > I'm not (yet) well-versed in postgresql, but have you tried creating symlinks? Rgds, --000e0ce02e2671c58604b19731a1 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable


On Nov 13, 2011 12:35 PM, "Michael George" <george@mutualdata.com> wrote:
>
> I am trying to upgrade my postgresql server from 9.0 to 9.1. =C2=A0I&#= 39;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 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ok
> Checking cluster versions =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 ok
> "/usr/lib64/postgresql-9.0/bin/pg_ctl" -w -l "/dev/null= " -D
> "/var/lib/postgresql/9.0/data" -o "-p 5432 -c autovacuu= m=3Doff -c
> autovacuum_freeze_max_age=3D2000000000" start >> "/dev= /null" 2>&1
>
> When I run that command manually and send the output to a logfile, it<= br> > appears that it's trying to find postgresql's *.conf files in = the data
> directory rather than in /etc/postgresql-9.0. =C2=A0I don't see a = way to
> specify the location of the conf files separate from the data files. >
> How do I proceed?
>

I'm not (yet) well-versed in postgresql, but have you tried creating= symlinks?

Rgds,

--000e0ce02e2671c58604b19731a1--