<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>Hello Videanu.<br><br>About question one, it seems to me, that this is a replication problem. In the postgresql.conf there is a parameter, called wal_keep_segments, this is the information written in the postgresql documentation about this parameter (...)Specifies the minimum number of past log file segments kept in the pg_xlog directory,<br>in case a standby server needs to fetch them for streaming replication. Each segment is<br>normally 16 megabytes. If a standby server connected to the primary falls behind by more than<br>wal_keep_segments segments, the primary might remove a WAL segment still needed by the<br>standby, in which case the replication connection will be terminated.<br>(...)<br><br>I recommend you increase this parameter in a value of 4000 or 5000.<br><br>About question 2, I have the same, but i think the answer is the same of you (that the postgresql is started on the slave node but it is not attached to the cluster). If you need attache a node you can use pcp_attach_node.<br><br>Regards.<br><br><br><hr id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;">Hi all, <br>i have a pgpool2 3.1.2 and 2 postgresql 9.1 nodes with streaming replication. I Also use pgpooladmin. The failover and recovery scenarious works just fine, but what i have a few questions regarding the slave recovery:<br>1. Let`s say that i have stopped the slave for some administrative reasons. First i have detached from the cluster and then i had stopped the postgresql process on the slave node. If a start this node after one day i have this kind of messages in my logs : <br>FATAL: timeline 36 of the primary does not match recovery target timeline 34.<br>Do i have to perform a full base backup upon this node ?<br><br>2. if i see this: <br>Down Running as standby server <br>is pgpooladmin what does this means ? that the postgresql is started on the slave node but it is not attached to the cluster (so no read queries will be send to this node) and if i want to attach it i have to run pcp_attach_node?<br><br>3. If i press the disconnect (pgpooladmin) on the master node the slave would not become master unless i kill/stop postgresql process on the master machine. Is this the normal behavior ?<br><br>Thanks,<br>Adrian Videanu<br>_______________________________________________<br>pgpool-general mailing list<br>pgpool-general@pgpool.net<br>http://www.pgpool.net/mailman/listinfo/pgpool-general<br><br>10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...<br>CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br><br>http://www.uci.cu<br>http://www.facebook.com/universidad.uci<br>http://www.flickr.com/photos/universidad_uci<br></blockquote><br></div>
<br><html>
<body>
<a href="http://www.uci.cu/">
<img src="http://universidad.uci.cu/email.gif"/>
</body>
</html>
<br></body></html>