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

[Gregory Shearman <zekeyg@gmail.com>]

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.