[pgpool-hackers: 404] Re: KeepAlive between pgpool and postgresql
Tatsuo Ishii
ishii at postgresql.org
Thu Nov 14 16:17:30 JST 2013
Thanks for the patch!
> Code to allow tcp keepalive connection. It helps to define dead postgres
> connections.
>
> based on ticket #83
>
> Recommended params for web server
>
> pg_keepalives_idle = 10 # TCP_KEEPIDLE, in seconds;
> pg_keepalives_interval = 3 # TCP_KEEPINTVL, in seconds;
> pg_keepalives_count = 5 # TCP_KEEPCNT;
You need to check the existence of TCP_KEEPALIVE and
SIO_KEEPALIVE_VALS in configure. See PostgreSQL's source code
(src/backend/libpq/pqcomm.c etc.)
> pg_syn_count = 3 # TCP_SYNCNT
>
>
> TCP_SYNCNT work on linux?
Don't know. Anyway pg_syn_count is not used anywhere else in your
patch. Is it intended?
--
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-hackers
mailing list