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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
