"cannot write to log file pg_upgrade_internal.log" when upgrading from Postgresql 9.1 to 9.3
18,379
Make sure that you run this command from a directory that is writable by the postgres
user, like /tmp
or /var/lib/postgresql
:
$ cd /tmp
$ usr/lib/postgresql/9.3/bin/pg_upgrade ...
Author by
Constantine M
Updated on June 12, 2022Comments
-
Constantine M almost 2 years
I keep on getting the above error whenever I run the following command via a postgres user.
/usr/lib/postgresql/9.3/bin/pg_upgrade \ -b /usr/lib/postgresql/9.1/bin/ \ -B /usr/lib/postgresql/9.3/bin/ \ -d /var/lib/postgresql/9.1/main \ -D /var/lib/postgresql/9.3/main
cannot write to log file pg_upgrade_internal.log Failure, exiting
I'm using Ubuntu 13.10. Both Postgresql 9.1 and 9.3 are running properly.