"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 ...
Share:
18,379
Constantine M
Author by

Constantine M

Updated on June 12, 2022

Comments

  • Constantine M
    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.