Thread: log_timestamp and SIGHUP?
Hi,
Postgres 7.2.x.
I just set log_timestamp=false and sent the postmaster a SIGHUP. But
still I have the timestamps. Doesn't that work? The docs don't say
that this is one of the "startup only" properties.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
Andrew Sullivan <andrew@libertyrms.info> writes:
> I just set log_timestamp=false and sent the postmaster a SIGHUP. But
> still I have the timestamps. Doesn't that work?
It sure looks like it should, modulo the fact that backends won't
re-read postgresql.conf until they next reach the
wait-for-client-command outer loop. You sure you SIGHUP'd the right
process?
regards, tom lane
On Tue, Mar 18, 2003 at 11:47:23PM -0500, Tom Lane wrote:
> It sure looks like it should, modulo the fact that backends won't
> re-read postgresql.conf until they next reach the
> wait-for-client-command outer loop.
Hmm. The outer loop should surely happen after a COMMIT/ROLLBACK,
right?
> You sure you SIGHUP'd the right process?
Well, assuming the postmaster.pid file wasn't lying. But yes,
because some of the other changes I made did take effect.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
Andrew Sullivan <andrew@libertyrms.info> writes:
> On Tue, Mar 18, 2003 at 11:47:23PM -0500, Tom Lane wrote:
>> It sure looks like it should, modulo the fact that backends won't
>> re-read postgresql.conf until they next reach the
>> wait-for-client-command outer loop.
> Hmm. The outer loop should surely happen after a COMMIT/ROLLBACK,
> right?
Yeah. [tries it] It works for me ...
I have another theory: if you change
#log_timestamp = false
to
log_timestamp = true
you cannot reverse that by returning the line to its original state:
the original state is a comment and won't cause the postmaster to change
its variable. You must say
log_timestamp = false
if you want to get the value changed back via SIGHUP.
(Sorry if that seems insulting to your intelligence ... but I've been
bit by it at least once myself ...)
regards, tom lane
On Thu, Mar 20, 2003 at 10:26:58AM -0500, Tom Lane wrote:
> Yeah. [tries it] It works for me ...
Well, I'm stumped, then. It definitely did not work (on multiple
tries) on the system where I did it.
> #log_timestamp = false
> to
> log_timestamp = true
> you cannot reverse that by returning the line to its original state:
No, I know this, too (one of the folks here made exactly that error
just the other day, actually).
It's not a big deal, really. I was just curious. And annoyed that
something is up, but I don't know what.
Thanks.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110