Does anyone have any advice on upgrading PostgreSQL?
For some reason my database files are incompatible with server. If I upgrade will the database files be made compatible with the server?
The data directory was initialized by PostgreSQL version 9.4
After changing the contents of PG_VERSION to 9.3.12, I get the following error:-
Failed to start database server : FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission denied pg_ctl: could not start server Examine the log output.
Any ideas as to what is wrong?
Did you check the log file? The above output indicate some kind permission problem. Are you running the server in the jail? Did you set up the cluster after you installed 9.3 version of the server? Is this a major or minor update?