On Wed, Mar 19, 2014 at 10:09 PM, acanada 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 60GB of RAM.
On 19 Mar 2014, at 21:11, Sethu Prasad 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 is missing at
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"
...
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 reb
