> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailtogsql-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.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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.
>
>


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly