Re: [GENERAL] 9.0 Streaming Replication Problem to two slaves

2011-08-02 Thread devrim
This message has been digitally signed by the sender. Re___GENERAL__9_0_Streaming_Replication_Problem_to_two_slaves.eml Description: Binary data - Hi-Tech Gears Ltd, Gurgaon, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make ch

Re: [GENERAL] 9.0 Streaming Replication Problem to two slaves

2011-08-02 Thread Devrim GÜNDÜZ
On Tue, 2011-08-02 at 11:55 -0600, Scott Marlowe wrote: > > Is this likely that the disks are too slow on the replication > > servers, or is something else happening, such as the restoration of > logs is considerably slower than on the primary? > > Could be. Are the drives on the slaves much sl

Re: [GENERAL] 9.0 Streaming Replication Problem to two slaves

2011-08-02 Thread Scott Marlowe
On Tue, Aug 2, 2011 at 9:24 AM, Michael Best wrote: > On 07/25/2011 11:38 AM, Michael Best wrote: >> >> I have the servers configured, and get the replication up and running, >> and then it will run for the better part of a day, and then the slaves >> appear to stop receiving or requesting updates

Re: [GENERAL] 9.0 Streaming Replication Problem to two slaves

2011-08-02 Thread Michael Best
On 07/25/2011 11:38 AM, Michael Best wrote: I have the servers configured, and get the replication up and running, and then it will run for the better part of a day, and then the slaves appear to stop receiving or requesting updates, there doesn't appear to be anything in the logs other than On

[GENERAL] 9.0 Streaming Replication Problem to two slaves

2011-07-25 Thread Michael Best
I have a master server and two slave servers, one in the same rack and one in another data center that has a normal latency of about 15ms. Both master and slaves are running CentOS 5.6 x86_64 with: postgresql90-server-9.0.4-1PGDG.rhel5.x86_64 from http://yum.pgrpms.org The master server is usin

Re: [GENERAL] 9.0 streaming replication problem

2011-03-09 Thread Sean Hsien
On 10 March 2011 14:21, Sean Hsien wrote: > Hi, > > I've setup 2 nodes for streaming replication and it was working > perfectly. I the tested multiple failovers, switching master/slave, > and now the streaming replication doesn't work anymore. > > I had a look at the log and it seems fine "LOG:  r

[GENERAL] 9.0 streaming replication problem

2011-03-09 Thread Sean Hsien
Hi, I've setup 2 nodes for streaming replication and it was working perfectly. I the tested multiple failovers, switching master/slave, and now the streaming replication doesn't work anymore. I had a look at the log and it seems fine "LOG: replication connection authorized: user=postgres ...". F