Thread: Clarification required
I could not understand the following TODO item. Can anyone explain this. Monitoring: ========= Allow server logs to be remotely read and removed using SQL commands Does it mean that the server log file should be read by the client? What kind of removal (using SQL)? Also I like to know where the server log file is stored. Thanks Dhanaraj
> -----Original Message----- > From: pgsql-hackers-owner@postgresql.org > [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Dhanaraj M > Sent: 12 May 2006 12:31 > To: pgsql-hackers@postgresql.org > Subject: [HACKERS] Clarification required > > I could not understand the following TODO item. > Can anyone explain this. > > Monitoring: > ========= > > Allow server logs to be remotely read and removed using SQL commands > > > Does it mean that the server log file should be read by the > client? What kind of removal (using SQL)? This is possible using the functions in the adminpack contrib module that's currently in the patch queue: http://candle.pha.pa.us/mhonarc/patches/msg00006.html > Also I like to know where the server log file is stored. Check your postgresql.conf file. Regards, Dave.
On Fri, May 12, 2006 at 05:00:51PM +0530, Dhanaraj M wrote: > I could not understand the following TODO item. > Can anyone explain this. > > Monitoring: > ========= > > Allow server logs to be remotely read and removed using SQL commands > > > Does it mean that the server log file should be read by the client? What > kind of removal (using SQL)? The log would be read by the server (backend process) and passed to the client, presumably via some function ie: SELECT pg_readlog(); > Also I like to know where the server log file is stored. It's configurable. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
The server log file means the files that are in pg_xlog. or some more/some other files? The log files in pg_xlog dir are not human readable. How is it useful on the client side? Dave Page wrote: > > >>could not understand the following TODO item. >>Can anyone explain this. >> >>Monitoring: >>========= >> >>Allow server logs to be remotely read and removed using SQL commands >> >> >>Does it mean that the server log file should be read by the >>client? What kind of removal (using SQL)? >> >> > >This is possible using the functions in the adminpack contrib module >that's currently in the patch queue: >http://candle.pha.pa.us/mhonarc/patches/msg00006.html > > > >>Also I like to know where the server log file is stored. >> >> >Check your postgresql.conf file. > >Regards, Dave. > >
> -----Original Message----- > From: Dhanaraj.M@Sun.COM [mailto:Dhanaraj.M@Sun.COM] > Sent: 18 May 2006 10:30 > To: Dave Page > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Clarification required > > The server log file means the files that are in pg_xlog. or > some more/some other files? > > The log files in pg_xlog dir are not human readable. How is > it useful on the client side? Not the transaction logs, the postmaster logs. Check the log_directory parameter if redirect_stderr is turned on, or the startup parameters for the server which can also specify the log location. Regards, Dave.