Re: search_path not reloaded via unix socket connections
| От | David G. Johnston |
|---|---|
| Тема | Re: search_path not reloaded via unix socket connections |
| Дата | |
| Msg-id | CAKFQuwbsyouFeX4HeO=RFpnfaQoCdk0-hrfVc9PCGhUYkHyoyQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | search_path not reloaded via unix socket connections (Kong Man <kong_mansatiansin@hotmail.com>) |
| Ответы |
Re: search_path not reloaded via unix socket connections
|
| Список | pgsql-general |
On Thursday, September 17, 2015, Kong Man <kong_mansatiansin@hotmail.com> wrote:
Can anybody explain why the search_path setting, with several config reloads, would not change via local connections? We struggled with our production settings on Postgres 9.3 today, only to realize, after a while, that the search_path change actually took effect via TCP/IP, but not unix socket, connections ever since the first reload.
What Tom said...
Alternatively maybe your Unix socket sessions are long lived but your TCP/IP ones are not - potentially going through a pooler that refreshes sessions. You need to describe more or provide repeatable evidence if we are to conclude that this is anything other than operator error.
David J.
В списке pgsql-general по дате отправления: