There is an ELOG_TIMESTAMPS options and some others in include/config.h or
include/config.h.in. I think that is where you get the pid of the
backend and stuff. I agree it needs more detail, at least the process
id.
[ Charset ISO-8859-1 unsupported, converting... ]
> I just have to setup a trong logging of users postgres activity using php
> script.
>
> It's work well and my disk is going full quickly.
> i have a file like this
>
> { TARGETENTRY
> :resdom
> { RESDOM
> :resno 2
> :restype 1043
> :restypmod 24
> :resname "abrev_formation"
> :reskey 0
> :reskeyop 0
> :resgroupref 0
> :resjunk false
> }
>
> it's to hard to exploit this file to extract a user and machine from where
> they work.
>
> Some help for managing logging
>
>
> Fouad Fezzi
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026