38

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.

isapir
  • 21,295
  • 13
  • 115
  • 116
Constantine M
  • 1,507
  • 2
  • 11
  • 8

3 Answers3

89

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 ...
Daniel Vérité
  • 58,074
  • 15
  • 129
  • 156
0

#run pg_upgrade command in new data directory path.

Ex: bash-4.2$ pwd

/var/lib/pgsql/11/data

bash-4.2$ /usr/pgsql-11/bin/pg_upgrade --old-datadir=/var/lib/pgsql/10/data --new-datadir=/var/lib/pgsql/11/data --old-bindir=/usr/pgsql-11/bin --new-bindir=/usr/pgsql-11/bin -c

user19389607
  • 1
  • 1
0

fix with chown: chown postgres:postgres /usr/lib/postgresql/9.3/bin

Sajad Abdollahi
  • 151
  • 1
  • 4