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@xxxxxxxxxxxxx > To: kong_mansatiansin@xxxxxxxxxxx > CC: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: search_path not reloaded via unix socket connections > Date: Thu, 17 Sep 2015 22:29:04 -0400 > > Kong Man <kong_mansatiansin@xxxxxxxxxxx> 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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
