[pgpool-general: 351] sync replication postgresql

Евгений Селявка evg.selyavka at gmail.com
Mon Apr 9 16:06:14 JST 2012


Dear users, I have two servers in sync mode, one master and second is slave:
 application_name |  client_addr  | client_port |   state   | sync_priority
| sync_state

----+-------------+-----------+---------------+------------------------------+-----------
 slave2           | 192.168.56.22 |       51055 | streaming |             1
| sync

But in pgpool i see this:

2012-04-09 10:37:28 LOG:   pid 23867: Replication of node:1 is behind 1976
bytes from the primary server (node:0)
2012-04-09 10:38:19 LOG:   pid 23867: Replication of node:1 is behind 2392
bytes from the primary server (node:0)

Why it is possible if in sync mode postgresql master wait until wal logs
write to slave?


-- 
С уважением Селявка Евгений
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120409/d107afea/attachment.html>


More information about the pgpool-general mailing list