[Pacemaker] pgsql RA

2014-05-19 Thread Евгений Селявка
Dear users, I use pacemaker RA script pgsql wich support the replication in schema with 2 non shared servers(servers are identical) this is my environment. Linux billing-db1 2.6.32-358.23.2.el6.x86_64 #1 SMP Wed Oct 19 18:37:12 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux [root@billing-db1 ~]# cat /e

Re: [Pacemaker] pgsql RA - slave is in HS:ASYNC status and won; t promote

2014-01-21 Thread 東一彦
Hi, Tomáš. > my slave node is still async, event the select you mentioned shows async .. Is "synchronous_standby_names" set correctly ? synchronous_standby_names is PostgreSQL's parameter. That is a list of standby names that can support synchronous replication(*). (* please see below for deta

Re: [Pacemaker] pgsql RA - slave is in HS:ASYNC status and won; t promote

2014-01-17 Thread Tomáš Vajrauch
Hi! thanks for help .. anyway - my slave node is still async, event the select you mentioned shows async .. at least i found out, that if i set rep_mode to "async", the slave node gets promoted when master fails ... so right now it is working, but i would like still know how to make streaming repli

Re: [Pacemaker] pgsql RA - slave is in HS:ASYNC status and won; t promote

2014-01-13 Thread 東一彦
Hi, > but after some tests something went wrong and i don't know what and why and how to get it back working ... now when i start crm, master is PRI, but slave gets into HS:ASYNC state .. and when master fails, and slave gets into HS:alone state It is PostgreSQL to select the node whether "sync

[Pacemaker] pgsql RA - slave is in HS:ASYNC status and won; t promote

2014-01-10 Thread Tomáš Vajrauch
Hi, i am trying to run postgresql cluster with streaming replication using pgsql RA and pacemaker .. i succeded once, master was as PRI, slave HS:sync, failover worked as it should (slave become master) .. but after some tests something went wrong and i don't know what and why and how to get it ba