[HACKERS] [doc fix] PG10: wroing description on connect_timeout when multiplehosts are specified
От | Tsunakawa, Takayuki |
---|---|
Тема | [HACKERS] [doc fix] PG10: wroing description on connect_timeout when multiplehosts are specified |
Дата | |
Msg-id | 0A3221C70F24FB45833433255569204D1F6F42F5@G01JPEXMBYT05 обсуждение исходный текст |
Ответы |
[HACKERS] Re: [doc fix] PG10: wroing description on connect_timeout whenmultiple hosts are specified
|
Список | pgsql-hackers |
Hello, Robert I found a wrong sentence here in the doc. I'm sorry, this is what I asked you to add... https://www.postgresql.org/docs/devel/static/libpq-connect.html#libpq-paramkeywords connect_timeout Maximum wait for connection, in seconds (write as a decimal integer string). Zero or not specified means wait indefinitely.It is not recommended to use a timeout of less than 2 seconds. This timeout applies separately to each connectionattempt. For example, if you specify two hosts and both of them are unreachable, and connect_timeout is 5, thetotal time spent waiting for a connection might be up to 10 seconds. The program behavior is that libpq times out after connect_timeout seconds regardless of how many hosts are specified. Iconfirmed it like this: $ export PGOPTIONS="-c post_auth_delay=30" $ psql -d "dbname=postgres connect_timeout=5" -h localhost,localhost -p 5432,5433 (psql erros out after 5 seconds) Could you fix the doc with something like this? "This timeout applies across all the connection attempts. For example, if you specify two hosts and both of them are unreachable,and connect_timeout is 5, the total time spent waiting for a connection is up to 5 seconds." Should we also change the minimum "2 seconds" part to be longer, according to the number of hosts? Regards Takayuki Tsunakawa
В списке pgsql-hackers по дате отправления: