Re: Logging question

On Mon, 17 Jan 2005 23:44:37 -0500, Madison Kelly <linux@alteeve.com> wrote:
> Tom Lane wrote:
> > Michael Fuhr <mike@fuhr.org> writes:
> >
> >>On Mon, Jan 17, 2005 at 09:03:17PM -0500, Madison Kelly wrote:
> >>
> >>>Is there any way I can log and/or display database calls for a
> >>>specific database?
> >
> >
> >>I don't know of a way to enable logging for a specific database,
> >>but you can enable logging for a specific user or session.
> >
> >
> >>ALTER USER johndoe SET log_statement TO TRUE;  -- 7.x
> >
> >
> > You forgot that ALTER DATABASE has this same option.  It might be that
> > ALTER USER is just as convenient, or even more so, for Madison's problem
> > ... but it *can* be set at the database scope if needed.
> >
> >                       regards, tom lane
> >
>
> Can I ask a horribly embarrising question?
>
> Where /is/ the log file? I've looked in the config file, in the init
> file, in /var/log, on google... no luck! ^.^;

In the 'official' 7.4.x RPMs look for the PGLOG variable in
/etc/init.d/postgresql and set that to where you want to generate the
log.


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       http://netllama.linux-sxs.org