[PERFORM] slave wal is ahead of master

2014-03-19 Thread Evgeniy Shishkin
Hello, we have 3 servers with postgresql 9.3.3. One is master and two slaves. We run synchronous_replication and fsync, synchronous_commit and full_page_writes are on. Suddenly master hang up with hardware failure, it is a strange bug in iLo which we investigate with HP. Before master was

Re: [PERFORM] slave wal is ahead of master

2014-03-19 Thread Sethu Prasad
fsync ... taking more knowledge around this will shed some light to understand this problem slave ahead of master there was silence, because master hang. ... replication halted here, master holds the latest copy which is missing at both the slaves I decided to promote one of the slaves ... only

Re: [PERFORM] slave wal is ahead of master

2014-03-19 Thread Evgeny Shishkin
On 19 Mar 2014, at 21:11, Sethu Prasad sethuprasad...@gmail.com wrote: fsync ... taking more knowledge around this will shed some light to understand this problem slave ahead of master there was silence, because master hang. ... replication halted here, master holds the latest copy which

Re: [PERFORM] Query taking long time

2014-03-19 Thread Venkata Balaji Nagothi
On Wed, Mar 19, 2014 at 10:09 PM, acanada acan...@cnio.es wrote: Hello, First of all I'd like to thank all of you for taking your time and help me with this. Thank you very much. I did migrate the database to the new server with 32 processors Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz and