[gentoo-user] pg_upgrade91 - You must have read and write access in the current directory

[gentoo-user] pg_upgrade91 - You must have read and write access in the current directory

[Joseph]

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?
Is it a bug?
http://postgresql.1045698.n5.nabble.com/Problem-with-pg-upgrade-s-directory-write-check-on-Windows-td4626004.html

-- 
Joseph

Re: [gentoo-user] pg_upgrade91 - You must have read and write access in the current directory

[Gregory Shearman]

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.

Re: [gentoo-user] pg_upgrade91 - You must have read and write access in the current directory

[Joseph]

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

Re: [gentoo-user] pg_upgrade91 - You must have read and write access in the current directory

[Gregory Shearman]

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

Re: [gentoo-user] pg_upgrade91 - You must have read and write access in the current directory

[Joseph]

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

Re: [gentoo-user] pg_upgrade91 - You must have read and write access in the current directory

[Gregory Shearman]

In linux.gentoo.user, you wrote:
> 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
>>
> 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.

I see. That's a shame.

Usually, the HOME directory of the postgres user is set to
/var/lib/postgresql.

If you just do "su postgres" you'll remain in the directory from which
you ran the command.

What you *must* do is run:

$ su - postgres

Notice the '-'?

This makes the su to the user a *login*, so that you'll be in the HOME
directory of the postgres user.

Try it yourself. Do an 'ls' after "su postgres" and then do an 'ls'
after "su - postgres"

See "man su" for more information.

-- 
Regards,
Gregory.