Re: Datestamps - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Datestamps
Date
Msg-id 20040109213925.GA17189@wolff.to
Whole thread Raw
In response to Re: Datestamps  (Bryan Irvine <bryan.irvine@kingcountyjournal.com>)
List pgsql-novice
On Fri, Jan 09, 2004 at 13:12:12 -0800,
  Bryan Irvine <bryan.irvine@kingcountyjournal.com> wrote:
> > > > Rows do not have timestamps associated with them. You might be able to make
> > > > some guesses using your logfile. If this is something you want for the
> > > > future you can add a timestamp field to your table and use a trigger to
> > > > keep it up to date.
>
> uhm, *digs toe into ground* where would my logfile be?

The logs might just be being thrown away. They might be being stored using
syslog in which case they would probably be in var/log somewhere. They
might be being saved into a file. Look at the commands used to start
the database server in this case to see where the file is.
For my use I save the logs using multilog, but I don't think any
distributor sets up postgres that way.

pgsql-novice by date:

Previous
From: bartvde@xs4all.nl
Date:
Subject: psql error: could not connect to server
Next
From: Bruno Wolff III
Date:
Subject: Re: psql error: could not connect to server