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