Francisco Reyes wrote: > Tom Lane writes: > > >The memory dump only comes out on stderr (I think because of paranoia > >about running out of memory while trying to report we're out of memory). > >Can you get the postmaster's stderr output? > > >From stderr > > pg_restore: restoring data for table "message_attachments" > pg_restore: [archiver (db)] Error from TOC entry 2146; 0 988154 TABLE DATA > message_attachments pgsql
This is pg_restore's stderr. What Tom wants to see is postmaster's. It is probably redirected (hopefully to a file, but regretfully it is common to see it go to /dev/null) on the init script that starts the service. If it's going to /dev/null, change it to somewhere more reasonable and try again. Or you could start the postmaster by hand on a terminal under your control. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq