PostgreSQL normally deletes the lock file when terminates correctly. It is probably due to another PostgreSQL instance running with a different user that has been terminated abnormally (a kill -9 to postmaster). So, if you are sure no Postgres processes are running, you can probably delete that file without any issue.
10/25/2019 · Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux, Notice that the permissions on the folder /var/run/postgresql change from 777 to 775 with a sticky bit on group when I try to start the daemon.The daemon actually changes these permissions to break operation.If I could change it to 777 permanently, at the very least I could find out what user postgresql was actually running as, and fix that, but no, the daemon changes its permissions to break …
I’m attempting to run the latest 9.6 container (have also tried the alpine container with the same result) with a non-default user. The data files are all created correctly by initdb, but the server itself never starts due to permission problems on /var/run/postgresql.. Using the following command to start the container:, [vagrant:~]$ sudo service postgresql restart Error: Cannot stat /var/run/postgresql * No PostgreSQL clusters exist ; see man pg_createcluster This is kind of odd. If you dig into the start up script, it’s supposed to create the /var/run/postgresql directory if it doesn’t exist . This leads me to believe we’re missing a piece of the pie when …
To reproduce and simulate installation on freshly installed system (WARNING: this will wipe your postgres databases!) urpme $(rpm -qa | grep ^postgresql9.3) 1>/dev/null; rm -rf /var/lib/pgsql ; rm -rf /var/run/postgresql #verify socket directory does not exist : ls -ald /var/run/postgresql #install and start postgres server, then check status …
The exact same symptom can be caused by a stale lock file /var/run/postgresql/.s.PGSQL.5432.lock. One of the symptoms of this is psql reporting . psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket /var/run/postgresql/.s.PGSQL.5432?
