How to switch from read-only slave to read-write after Postgres Master Failure?

February 5, 2017 1.1k views
PostgreSQL Ubuntu 16.04

Hi, I was wondering how easy is to convert the read-only slave to read-write while the Master is down. There is a tutorial here that provides a step-by-step procedure on how to streamline a replication process. However, it does not provide info on what to do after the Master goes down for a reason.

And I also had a tough time locating something relevant on the internet.

An help, url, suggestion will be kindly welcomed.

1 Answer

Try this one it mighthelp

 WITH sel AS (
   SELECT id
   FROM   univ.domains
   WHERE  name = domain_name

See this for full info

Have another answer? Share your knowledge.