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

February 5, 2017 3k views
PostgreSQL Ubuntu 16.04
xpanta
By:
xpanta

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.

Sign In to Comment
2 Answers
azhar5012 February 6, 2017

Try this one it mighthelp

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

See this for full info

Report
info699f11ebb5626f85fe1898 January 28, 2019

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

Report
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!

Related