xpanta
By:
xpanta

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

February 5, 2017 180 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

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

See this for full info

Have another answer? Share your knowledge.