Linux Archive

Linux Archive (http://www.linux-archive.org/)
-   Gentoo User (http://www.linux-archive.org/gentoo-user/)
-   -   pg_upgrade91 - You must have read and write access in the current directory (http://www.linux-archive.org/gentoo-user/606414-pg_upgrade91-you-must-have-read-write-access-current-directory.html)

Gregory Shearman 12-05-2011 01:37 AM

pg_upgrade91 - You must have read and write access in the current directory
 
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.

--
Regards,
Gregory.

Joseph 12-05-2011 02:25 AM

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
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.

--
Regards,
Gregory.


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


All times are GMT. The time now is 12:26 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.