Where Is My Recovery.Conf File in PostgreSQL v12?

October 15, 2019

The short answer is: it’s gone.

With PostgreSQL v12,  “recovery.conf” is no longer valid. Even if someone were to create a recovery.conf file manually and keep it under the data directory, the server is not going to start and will throw the following error:

The parameter “standby_mode =on”, which used to be the #1 parameter of the recovery.conf file, has also been removed from PostgreSQL v12. Also, the “trigger_file” parameter name has been changed to “promote_trigger_file.”

Other parameters for recovery.conf are valid and can be written in the “postgresql.conf” file of the replica cluster.  

It actually makes more sense if all the required information is mentioned in one file—i.e.,  postgresql.conf—rather than creating and managing separate files.

“standby.signal”—which is an empty file—has replaced the recovery.conf file and the presence of this file will signal to the cluster to run in standby mode.

Continue reading on Postgres Rocks for a step-by-step guide to setting up streaming replication and failover in PostgreSQL v12.


Share this

Relevant Blogs

The Varying Cost of Synchronous Replication

Synchronous replication in Postgres is expensive. Very expensive. For any transaction to complete in a synchronous context, it must be acknowledged by at least one allocated replica system. Depending on...
February 23, 2023

More Blogs

What’s New in Postgres 15: Webinar Highlights

Recently, EDB hosted an exciting webinar entitled “What’s New in Postgres 15,” which covered the development process for the latest version of PostgreSQL, as well as new features and benefits...
January 15, 2023