Обсуждение: 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 ?

>
>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 #