[Pacemaker] Postgresql replication problems

Hi all. After one year using Postgresql Cluster like this configuration[0], start to fail, and I don't know why :-( In the last days, my database move to the second machine, and always had pgsql-status: HS:SYNC, but I don't know why second server didn't wake up correctly and pacemaker moved agai

Re: [Pacemaker] Postgresql Replication

On 12/09/2013, at 11:58 PM, Takatoshi MATSUO wrote: > Hi > > 2013/9/12 Eloy Coto Pereiro : >> Hi, >> >> Thanks for your help, I use the same example. In this case Kamailio need to >> start after postgresql. But this is not a problem I think, the replication >> work ok without corosync. I stop

Re: [Pacemaker] Postgresql Replication

Hi 2013/9/12 Eloy Coto Pereiro : > Hi, > > Thanks for your help, I use the same example. In this case Kamailio need to > start after postgresql. But this is not a problem I think, the replication > work ok without corosync. I stop all process and start to work with > corosync. > > When I start cor

Re: [Pacemaker] Postgresql Replication

Hi, Thanks for your help, I use the same example. In this case Kamailio need to start after postgresql. But this is not a problem I think, the replication work ok without corosync. I stop all process and start to work with corosync. When I start corosync I see this log in my slave: Sep 12 16:12:

Re: [Pacemaker] Postgresql Replication

Hi Eloy 2013/9/12 Eloy Coto Pereiro : > Hi, > > I have issues with this config, for example when master is running corosync > service use pg_ctl. But in the slave pg_ctl doesn't start and replication > doesn't work. > > This is my data: > > > Online: [ master slave ] > OFFLINE: [ ] > > Full list

Re: [Pacemaker] Postgresql Replication

Hi, I have issues with this config, for example when master is running corosync service use pg_ctl. But in the slave pg_ctl doesn't start and replication doesn't work. This is my data: Online: [ master slave ] OFFLINE: [ ] Full list of resources: ClusterIP (ocf::heartbeat:IPaddr2): Started ma

Re: [Pacemaker] Postgresql Replication

Hi Eloy Please see http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster . In the document, it uses virtual IP to receive connection, so it doesn't need to change recovery.conf. Thanks, Takatoshi MATSUO 2013/9/11 Eloy Coto Pereiro : > Hi, > > In Postgresql if you use wal replication >

[Pacemaker] Postgresql Replication

Hi, In Postgresql if you use wal replication < http://wiki.postgresql.org/wiki/Streaming_Replication> when the master servers fails need to change the recovery.conf on the slave server. In this case any tool, when the master is down, execute a command and get this info? Is this the right tool for