Hi, I have a pair of PG servers, a master and a replica, all read-write queries are handled by the master, read-only ones are by the replica.
>From time to time the replica itself is too busy, all read-only queries will >get inconsistent results because of replication lag, sometimes it can be >longer than 6 minutes. I am thinking to add multiple replicas to off-load >read-only queries, can you please suggest a way to monitor and failover the >read-only query when the replication lag in a replica is more than 5 minutes? regards -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
