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

February 5, 2017 3k 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.

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

Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!