Gentoo Archives: gentoo-user

From: Joseph <syscon780@×××××.com>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] pg_upgrade91 - You must have read and write access in the current directory
Date: Mon, 05 Dec 2011 03:26:39
Message-Id: 20111205032531.GE28855@syscon4.inet
In Reply to: Re: [gentoo-user] pg_upgrade91 - You must have read and write access in the current directory by Gregory Shearman
1 On 12/05/11 13:37, Gregory Shearman wrote:
2 >In linux.gentoo.user, Joseph wrote:
3 >> I'm upgrading form posgresql 9.0 to 9.1, it seem to the upgrade went OK but when try to transfer the data
4 >> base:
5 >> pg_upgrade91 -v --old-datadir=/var/lib/postgresql/9.0/data/ --new-datadir=/var/lib/postgresql/9.1/data
6 >> --old-bindir=/usr/lib/postgresql-9.0/bin/ --new-bindir=/usr/lib/postgresql-9.1/bin/
7 >> Running in verbose mode
8 >> Performing Consistency Checks
9 >> -----------------------------
10 >> Checking current, bin, and data directories
11 >> You must have read and write access in the current directory.
12 >> Failure, exiting
13 >>
14 >> What am I doing wrong?
15 >
16 >Have you checked that you have read and write access in the current
17 >directory before running the command?
18 >
19 >I did the upgrade as the "postgres" user and made sure that I ran the
20 >command from a read/writable directory for that user.
21 >
22 >--
23 >Regards,
24 >Gregory.
25
26 Yes, I did "su postgres"
27 and ls -al /var/lib/postgresql/9.1/
28 drwx------ 13 postgres postgres 4096 Dec 4 18:20 data
29
30 so it should work.
31
32 --
33 Joseph