Streaming replication : cannot promote to master while master is down

[apompee]

Streaming replication : cannot promote to master while master is down

[NyakudyaA]

Looks like there are a couple of settings that need to be fixed.

• pg-node needs to be running in order to initiate a promotion.

So rather exec into the container and run

    pg_ctl promote -D ${DATADIR}

Then scale down master and start the pg-node container

Can you confirm if this works and I will do a PR later to auto fix this logic

[apompee]

I just did the test. I scaled down the master before promoting the node.
To promote the node, I had to do :

# . env-data.sh 
# su postgres -c "pg_ctl promote -D ${DATADIR}"
waiting for server to promote.... done
server promoted

Then, I could insert into the database without restarting anything :

gis=# INSERT INTO sweets (name ,price) values ('Test', 10);
INSERT 0 1
gis=# select * from sweets; 
 id |    name    | price 
----+------------+-------
  1 | strawberry |  4.50
  2 | Coffee     |  6.20
  3 | lollipop   |  3.80
  4 | Test       |    10