RE: Timeout parameters

Поиск
Список
Период
Сортировка
Искать
От
Tsunakawa, Takayuki
Тема
RE: Timeout parameters
Дата
Msg-id
0A3221C70F24FB45833433255569204D1FBC4065@G01JPEXMBYT05
Ответ на
RE: Timeout parameters (Fabien COELHO)
Список
Дерево обсуждения
Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
Re: Timeout parameters Fabien COELHO <coelho@cri.ensmp.fr>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters Fabien COELHO <coelho@cri.ensmp.fr>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters Fabien COELHO <coelho@cri.ensmp.fr>
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: Timeout parameters AYahorau@ibagroup.eu
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
Re: Timeout parameters Michael Paquier <michael@paquier.xyz>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters "Jamison, Kirk" <k.jamison@jp.fujitsu.com>
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: Timeout parameters "Jamison, Kirk" <k.jamison@jp.fujitsu.com>
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: Timeout parameters "Jamison, Kirk" <k.jamison@jp.fujitsu.com>
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters "Jamison, Kirk" <k.jamison@jp.fujitsu.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters "Jamison, Kirk" <k.jamison@jp.fujitsu.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters Fabien COELHO <coelho@cri.ensmp.fr>
RE: Timeout parameters Fabien COELHO <coelho@cri.ensmp.fr>
RE: Timeout parameters Fabien COELHO <coelho@cri.ensmp.fr>
RE: Timeout parameters "Jamison, Kirk" <k.jamison@jp.fujitsu.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters Fabien COELHO <coelho@cri.ensmp.fr>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
Re: Timeout parameters Robert Haas <robertmhaas@gmail.com>
Re: Timeout parameters Fabien COELHO <coelho@cri.ensmp.fr>
Re: Timeout parameters Robert Haas <robertmhaas@gmail.com>
Re: Timeout parameters Fabien COELHO <coelho@cri.ensmp.fr>
Re: Timeout parameters Robert Haas <robertmhaas@gmail.com>
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Timeout parameters Robert Haas <robertmhaas@gmail.com>
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Timeout parameters Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Timeout parameters Robert Haas <robertmhaas@gmail.com>
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Timeout parameters Robert Haas <robertmhaas@gmail.com>
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: Timeout parameters MikalaiKeida@ibagroup.eu
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters MikalaiKeida@ibagroup.eu
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
Re: Timeout parameters Robert Haas <robertmhaas@gmail.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters MikalaiKeida@ibagroup.eu
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: Timeout parameters "Jamison, Kirk" <k.jamison@jp.fujitsu.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: Timeout parameters Fabien COELHO <coelho@cri.ensmp.fr>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
Re: Timeout parameters AYahorau@ibagroup.eu
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
RE: Timeout parameters "Nagaura, Ryohei" <nagaura.ryohei@jp.fujitsu.com>
From: Fabien COELHO [mailto:coelho@cri.ensmp.fr]
> >> If the user reconnects, eg "\c db", the setting is lost. The
> >> re-connection handling should probably take care of this parameter, and
> maybe others.
> > I think your opinion is reasonable, but it seems not in this thread.
> 
> HI think that your patch is responsible for the added option at least.
> 
> I agree that the underlying issue that other parameters should probably
> also be reused, which would be a bug fix, does not belong to this thread.

This doesn't seem to be a bug.  \connect just establishes a new connection, not reusing the previous settings for most connection parameters.  As the examples in the following manual page show, the user needs to specify necessary connection parameters.

https://www.postgresql.org/docs/devel/app-psql.html

=> \c service=foo
=> \c "host=localhost port=5432 dbname=mydb connect_timeout=10 sslmode=disable"


But I'm afraid the description of \connect may not be clear enough about connection parameters, and that may cause users to expect the reuse of all connection parameter settings.  Anyway, I think this would be an improvement for psql's documentation or new feature for psql.  What do you think?


Regards
Takayuki Tsunakawa




В списке pgsql-hackers по дате отправления
От: Ashwin Agrawal
Дата:
От: Tom Lane
Дата:
FAQ