When I tried to run
psql, I got
psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
and when I checked
Server.log, I saw:
FATAL: database files are incompatible with server DETAIL: The data directory was initialized by PostgreSQL version 9.5, which is not compatible with this version 9.6.1.
I tried to follow this tutorial (from 9.4 to 9.5) for upgrading 9.6.1, but keep getting this error message
cannot write to log file pg_upgrade_internal.log Failure, exiting
$ pg_upgrade -v \ > -d /usr/local/var/postgres \ > -D /usr/local/var/postgres9.6.1 \ > -b /usr/local/Cellar/postgresql/9.5/bin/ \ > -B /usr/local/Cellar/postgresql/9.6.1/bin/
Does anyone have any idea what I am missing/doing wrong? Thanks!
- MacOS 10.12.2
- PostgreSQL installed with Homebrew