pg_upgrade91 - You must have read and write access in the current directory
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
pg_upgrade91 -v --old-datadir=/var/lib/postgresql/9.0/data/ --new-datadir=/var/lib/postgresql/9.1/data
Running in verbose mode
Performing Consistency Checks
Checking current, bin, and data directories
You must have read and write access in the current directory.
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.