Search Postgresql Archives

Re: changing log_min_duration_statement

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ben Chobot <bench@xxxxxxxxxxxxxxx> writes:
> On Jan 19, 2010, at 1:44 PM, Devrim GÜNDÜZ wrote:
>> Also, a distro (Gentoo) has 2 conf files which overrides some settings
>> in postgresql.conf -- you may suffer from something similar.

> Not to my knowledge. I'm on debian, and I'm editing the file listed in config_file. And, like I said, changing other values in that file works.

Another possibility is that the value was set on the postmaster command
line (ie, in the startup script) or via ALTER DATABASE or ALTER USER.
IIRC any one of those would override the config file, though of course
the latter two only for some sessions.

You might try looking at the pg_settings row for the variable to see
what it says the source is.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux