[pgpool-general: 413] Re: pgpool2 status info

Tatsuo Ishii ishii at postgresql.org
Sun May 6 10:54:31 JST 2012


> Hi Ruben,
> 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.
> 
> 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.
> 
> Regarding the second question maybe we can find someone to confirm our suppositions :)

I think Ruben is right.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the pgpool-general mailing list