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

What is pgvector and How Can It Help You?

With pgvector extension, you don’t need a specialized vector database, you can just use Postgres! Using pgvector you can now store vectors (embeddings), query them, use special index types to...
November 03, 2023

PostgreSQL 16 Update: Grouping Digits in SQL

One of the exciting new features in PostgreSQL 16 is the ability to group digits in numeric literals by separating them with underscores. This blog post covers the details.
October 17, 2023

More Blogs

pgAdmin CI/CD

Almost exactly three years ago I wrote a blog on my personal page entitled Testing pgAdmin which went into great detail discussing how we test pgAdmin prior to releases. Back...
August 24, 2023