In linux.gentoo.user, you wrote: > On 12/05/11 13:37, Gregory Shearman wrote: >>In linux.gentoo.user, Joseph wrote: >>> I'm upgrading form posgresql 9.0 to 9.1, it seem to the upgrade went OK but >>> when try to transfer the data >>> base: >>> pg_upgrade91 -v --old-datadir=/var/lib/postgresql/9.0/data/ >>> --new-datadir=/var/lib/postgresql/9.1/data >>> --old-bindir=/usr/lib/postgresql-9.0/bin/ >>> --new-bindir=/usr/lib/postgresql-9.1/bin/ >>> Running in verbose mode >>> Performing Consistency Checks >>> ----------------------------- >>> Checking current, bin, and data directories >>> You must have read and write access in the current directory. >>> Failure, exiting >>> >>> What am I doing wrong? >> >>Have you checked that you have read and write access in the current >>directory before running the command? >> >>I did the upgrade as the "postgres" user and made sure that I ran the >>command from a read/writable directory for that user. > > Yes, I did "su postgres" > and ls -al /var/lib/postgresql/9.1/ > drwx------ 13 postgres postgres 4096 Dec 4 18:20 data > > so it should work. > > -- > Joseph
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
