On Mon, 17 Jan 2005 23:44:37 -0500, Madison Kelly <linux@xxxxxxxxxxx> wrote: > Tom Lane wrote: > > Michael Fuhr <mike@xxxxxxxx> 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@xxxxxxxxx LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
