<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hi Ruben,<br>I have modified the wal_keep_segments to 5000, but i guess that this should be parametrized depending on how long do you plan to keep the slave down and how much traffic do you have towards the database. Thanks for the hint.<br><br>I`m planning to have a slave node on a server the is powered off every night, so just before the machine will shutdown i will detach the node from cluster and then stop postgresql process. Then in the morning i will start the postgresql process and after 1 min i will attach the node to the cluster.<br><br>Regarding the second question maybe we can find someone to confirm our suppositions :)<br><br>Thanks,<br>Adrian Videanu<br>--- On <b>Fri, 5/4/12, Lazaro Ruben Garcia Martinez <i><lgarciam@uci.cu></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left:
5px;"><br>From: Lazaro Ruben Garcia Martinez <lgarciam@uci.cu><br>Subject: Re: [pgpool-general: 408] pgpool2 status info<br>To: "Videanu Adrian" <videanuadrian@yahoo.com><br>Cc: pgpool-general@pgpool.net<br>Date: Friday, May 4, 2012, 3:39 PM<br><br><div id="yiv975349578"><style type="text/css">#yiv975349578 p {margin:0;}</style><div><div style="font-family: Times New Roman; font-size: 14pt; color: rgb(0, 0, 0);">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="yiv975349578zwchr"><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px; color: rgb(0, 0, 0); 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>
<div>
<a rel="nofollow" target="_blank" href="http://www.uci.cu/">
<img src="http://universidad.uci.cu/email.gif">
</a></div>
<a rel="nofollow" target="_blank" href="http://www.uci.cu/"><br></a></div></div></blockquote></td></tr></table>