The Data Directory Contains an Old File

Table of Contents


PostgreSQL Connection Failure

Sometimes, computers have a life of their own. You shut down your laptop and on the next boot, you are unable to connect to a PostgreSQL 12 database.

Opening the installed, I notice it displays stale file error.

alt=“stale postmaster-pid file”

What the heck is the file? Turns out that the is a lock file used to prevent two instances of the same PostgreSQL server from running on the same data-directory.

While the server is running, its PID is stored in the file in the data directory. This is used to prevent multiple server instances from running in the same data directory and can also be used for shutting down the server.

This is the first time I am encountering such an error. I click on the Start button to force a re-start and I get back a dialog with the following message: The data directory contains a file, which usually means that the server is already running. When the server crashes or is killed, you have to remove this file before you can restart the server. Make sure that the database process is definitely not running anymore, otherwise your data directory will be corrupted.

alt=“The data directory contains old  file”

Click on OK button to close the dialog window.

Resolving the Problem

  1. Open
  2. Click on Server Settings…
  3. Click on Show button next to the Data Directory. This should open the data directory of your PostgreSQl installation. alt=“ server settings”
  4. Locate the file alt=“postgresql data directory folder”
  5. Delete the file. Right click on the file and select Move to Bin alt=“postgresql delete file”
  6. After deleting the file, opening or making the Postgres GUI app window have focus will change the error message from stale file to Not running. Click Start button on Postgres GUI app to start PostgreSQL server. alt=“postgresql server  not running error”

Way Forward

Why not let PostgreSQL auto remove a stale file? This would make a user manage a PostgreSQL database without knowing its internal workings. Pros and cons of auto removing a stale exist and balancing between these two is not easy. Therefore, as at the time of this writing, the auto removal of the file remains an open issue and the user’s responsibility.

Further Reading