Jeff Amiel wrote:
> I notice in the log entries for the out of memory events have no username, database name or host
> identifier (while regular logged events do) Does that mean anything to anybody?
>
> Aug 28 08:25:50 db-1 postgres[29019]: [ID 748848 local0.warning] [111900-1] 2007-08-28
> 08:25:50.081 CDT 29019ERROR: out of memory
> Aug 28 08:25:50 db-1 postgres[29019]: [ID 748848 local0.warning] [111900-2] 2007-08-28
> 08:25:50.081 CDT 29019DETAIL: Failed on request of size 536870910.
>
> (regular log entry)
> Aug 28 08:26:45 db-1 postgres[28785]: [ID 748848 local0.info] [114999-1] 2007-08-28 08:26:45.413
> CDT jboss prod 192.168.20.44 28785LOG: duration: 22606.146 ms execute <unnamed>: select
Interesting. What's your log_line_prefix? Does it have "%q" somewhere?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support