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