[Pacemaker] setup advice

Stefano Sasso stesasso at gmail.com
Wed Jul 3 07:36:01 UTC 2013


>
> Does "standby" mean that PostgreSQL is stopped ?
> If Master doesn't have WAL files which new slave needs,
> new slave can't connect master.
>
> How do you solve it ?
> copy data or wal-archive on start automatically ?
> It may cause timed-out if PostgreSQL has large database.


I'm using streaming replication.

 1. First boot
> RA compares data and promotes PostgreSQL which has latest data.
> The number of comparison can be changed  using xlog_check_count parameter.
> If monitor interval is 10 sec and xlog_check_count is 360, RA can wait
> 1 hour to promote :)


I can't wait an hour :)
my maximum is 10 minutes :)

thanks
stefano
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20130703/07a2f444/attachment.htm>


More information about the Pacemaker mailing list