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 1RXcqG-0006Lb-Qd for garchives@archives.gentoo.org; Mon, 05 Dec 2011 18:00:41 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id E06BA21C04E; Mon, 5 Dec 2011 18:00:30 +0000 (UTC) Received: from mail.shawcable.com (shawmail.shawcable.com [64.59.128.220]) by pigeon.gentoo.org (Postfix) with ESMTP id 10C4721C048 for ; Mon, 5 Dec 2011 17:58:42 +0000 (UTC) Received: from bpd2mi1no-svcs.prod.shawcable.com ([10.0.184.120]) by bpd2mo2no-ssvc.prod.shawcable.com with ESMTP; 05 Dec 2011 10:58:42 -0700 X-Cloudmark-SP-Filtered: true X-Cloudmark-SP-Result: v=1.1 cv=rhzBfl3TH6jSClqh7E8qe//hARbvbzCI0ETuu7/2kJU= c=1 sm=1 a=wom5GMh1gUkA:10 a=8xuba47sJ3AA:10 a=nDghuxUhq_wA:10 a=BLceEmwcHowA:10 a=8nJEP1OIZ-IA:10 a=dgx804EzjhD8CRYpIFkhZA==:17 a=uLrnN_nnqTQWiyUh6lcA:9 a=RlVc1ZisG5ZSZMqD-gwA:7 a=wPNLvfGTeEIA:10 a=HpAAvcLHHh0Zw7uRqdWCyQ==:117 X-IronPort-AV: E=Sophos;i="4.71,300,1320649200"; d="scan'208";a="630671215" Received: from unknown (HELO bpd2mi1no-cmts.prod.shawcable.com) ([192.168.183.120]) by bpd2mi1no-cmts.prod.shawcable.com with ESMTP; 05 Dec 2011 10:58:42 -0700 X-reinject: true Received: from unknown (HELO syscon4.localdomain) ([68.148.245.78]) by bpd2mi1no-dmz.prod.shawcable.com with ESMTP; 05 Dec 2011 10:58:42 -0700 Received: by syscon4.localdomain (Postfix, from userid 1000) id C3A66C3AA3; Mon, 5 Dec 2011 10:59:17 -0700 (MST) Date: Mon, 5 Dec 2011 10:59:17 -0700 From: Joseph To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] pg_upgrade91 - You must have read and write access in the current directory Message-ID: <20111205175917.GF28855@syscon4.inet> References: <20111205105659.GA16909@pacific.net.au> 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=iso-8859-1; format=flowed Content-Disposition: inline In-Reply-To: <20111205105659.GA16909@pacific.net.au> User-Agent: Mutt/1.5.21 (2010-09-15) X-Archives-Salt: c37d81fb-91f5-4d5c-9b55-22cb5cefedfb X-Archives-Hash: 36a9572a1df6268eac58b8b8d22d5267 On 12/05/11 21:56, Gregory Shearman wrote: >hmmm... > >Which directory are you running the command from? I ran mine from >/var/lib/postgresql which has the properties: > >drwxr-xr-x 4 postgres root > >I don't recall using the command "pg_upgrade91", but I see that it is a >symlink to /usr/lib/postgresql-9.1/bin/pg_upgrade > >This is the command that worked for me: > >pg_upgrade -u postgres -d /var/lib/postgresql/9.0/data -D \\ >/var/lib/postgresql/9.1/data -b /usr/lib/postgresql-9.0/bin -B \\ >/usr/lib/postgresql-9.1/bin > >For more information do (as postgres user) > >$ pg_upgrade --help > >-- >Regards, >Gregory > I definitely wasn't in that directory I just "su postgres" and run the command. I just recreate the databases by hand and populated them with backup data. -- Joseph