Re: search_path not reloaded via unix socket connections

On 09/18/2015 08:19 AM, Kong Man wrote:
> Tom,
> I have made sure that the per-user and per-database settings are reset.
>   The old search_path setting still persists whenever I reconnect via
> local connections no matter what user I log in as.

So exactly how are you connecting and from what?

In other words the connection string and what client are you using?

>
>  > From: tgl@sss.pgh.pa.us
>  > To: kong_mansatiansin@hotmail.com
>  > CC: pgsql-general@postgresql.org
>  > Subject: Re: [GENERAL] search_path not reloaded via unix socket
> connections
>  > Date: Thu, 17 Sep 2015 22:29:04 -0400
>  >
>  > Kong Man <kong_mansatiansin@hotmail.com> writes:
>  > > 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.
>  >
>  > That's, um, pretty hard to believe. Less magical interpretations would
>  > involve something like a per-user or per-database setting overriding
>  > what's in the config file in some sessions but not others. But I really
>  > really doubt that TCP vs unix socket is the determining factor.
>  >
>  > regards, tom lane


--
Adrian Klaver
adrian.klaver@aklaver.com