I am using PG 9.1.2 and I am promoting a slave to master with the
pg_ctl promote -D /pat/to/data
Command does return back faster with code 0 ( = success). I assumed the
slave is now the master and issued write operations. But the statement
failed as the DB complained that it can do only read operation.
Postgres.log showed "ready to accept connection" a second later after I
issued the statement. So, my understanding is "pg_ctl promote" is
triggering a slave promote and is "asynchornous".
-- Anyway I can query the state of DB to know its status slave or master
?? So, that i can issue write statements only after I know that the DB
is the new master now
-- Or anyway to make pg_ctl promote to wait till the slave is completely
Any help is appreciated.
|PostgreSQL and IPV6||2|
|psql died in midst of session||1|
|Queries take long long(10 sec.) time running||5|
|Re: looking for a faster way to do that||0|
|.psqlrc and custom functions (mysql-like)||1|
|Protocol question - fastpath & parameter status 'S'||2|
|maybe incorrect regexp_replace behavior in v8.3.4 ?||2|
|One transaction by connection - commit subdetails without release master transaction?||4|
|consecutive analyze calls with different column lists.||0|