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

Posted February 5, 2017 5.5k views
PostgreSQLUbuntu 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.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
2 answers

Try this one it mighthelp

 WITH sel AS (
   SELECT id
   WHERE  name = domain_name

See this for full info

Hi Guys, Is it possible to create write permission in slave which means create a different table or different database