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