Minor (very) feature request...
Would it be (is it?) possible to add timestamp to the log
messages put out by postgresql? I've got several databases
running in an environment where users have this annoying
habit of coming up to me with ("Oh yes, three days ago around
4pm our instrument had trouble writing to database X.").
Having some way of telling which messages were output when
would be helpful in such cases, since I'm not allowed to
beat the users into submission...
Thanks!
--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.
run it through syslog?
On Thu, 4 Dec 2003, Steve Wampler wrote:
Would it be (is it?) possible to add timestamp to the log
messages put out by postgresql? I've got several databases
running in an environment where users have this annoying
habit of coming up to me with ("Oh yes, three days ago around
4pm our instrument had trouble writing to database X.").Having some way of telling which messages were output when
would be helpful in such cases, since I'm not allowed to
beat the users into submission...Thanks!
--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
Marc G. Fournier wrote:
run it through syslog?
or set "log_timestamp = true" in postgresql.conf ?
Show quoted text
On Thu, 4 Dec 2003, Steve Wampler wrote:
Would it be (is it?) possible to add timestamp to the log
messages put out by postgresql? I've got several databases
running in an environment where users have this annoying
habit of coming up to me with ("Oh yes, three days ago around
4pm our instrument had trouble writing to database X.").Having some way of telling which messages were output when
would be helpful in such cases, since I'm not allowed to
beat the users into submission...
On Thu, 2003-12-04 at 09:52, Andrew Dunstan wrote:
Marc G. Fournier wrote:
run it through syslog?
or set "log_timestamp = true" in postgresql.conf ?
Thanks - for some reason I was assuming that only applied
to logging connections. Should have tried it...
Thanks again!
--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.
Steve Wampler wrote:
Would it be (is it?) possible to add timestamp to the log
messages put out by postgresql? I've got several databases
running in an environment where users have this annoying
habit of coming up to me with ("Oh yes, three days ago around
4pm our instrument had trouble writing to database X.").Having some way of telling which messages were output when
would be helpful in such cases, since I'm not allowed to
beat the users into submission...
I thought the postgresql.conf option log_timestamp was added precisely
for that purpose.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #