FATAL: lock file already exists

You may receive this error when there are multiple IPs on the same server that use the same port. In this case, you cannot run the postgresql service. You may encounter an error like the following when you try to start PostgreSQL Service.

Start PostgreSQL

Check PostgreSQL Status

We will also see these errors when we check the status of the PostgreSQL service with the following script.

Solution

When we delete locks in the following way, we can start postgresql without receiving these errors.

Note: You must have set the IP from postgresql.conf.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *