Postgres is failing with 'could not open relation mapping file "global/pg_filenode.map" '
I am not sure what the source of my original problem was with 9.0.3 because I was getting this problem:
psql: FATAL: could not open relation mapping file "global/pg_filenode.map": No such file or directoryHowever as stated above it turns out that the running process was for my previous postgres install of 9.0.3
I believe I had an old version org.postgresql.postgres.plist in ~/Library/LaunchAgents/
I had to:
- Remove and re-add the launch agent
- Kill the processes for 9.0.3
- Initialize the db
initdb /usr/local/var/postgres - Restart my computer
and now I have it up and working.
That may be a permission issue, Please check the owner and group of configuration files in /var/lib/pgsql/9.3/data/
chown -R postgres:postgres /var/lib/pgsql/9.3/data/solved the issue for me
Encountered this problem using mdillon/postgis:9.6 Docker image. Simple sudo docker restart <container id> solved the problem.