From: Tom Lane <tgl@sss.pgh.pa.us>
To: warren little <warren.little@meridiascapital.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Emergency - Need assistance
Date: Mon, 02 Jan 2006 17:34:21 -0500
Message-ID: <12864.1136241261@sss.pgh.pa.us> (raw)
In-Reply-To: <1136240683.16094.40.camel@sharp>
References: <1136228730.16094.12.camel@sharp>
<11864.1136232604@sss.pgh.pa.us>
<1136233928.16094.33.camel@sharp>
<12399.1136237657@sss.pgh.pa.us>
<1136240683.16094.40.camel@sharp>
warren little <warren.little@meridiascapital.com> writes:
> The dump/restore failed even with the zero_damaged_pages=true.
> The the logfile (postgresql-2006-01-02_130023.log)
> did not have much in the way of useful info. I've attached the section
> of the logfile around the time of the crash. I cannot find any sign of
> a core file. Where might the core dump have landed?
It would typically go into $PGDATA (if you're using 8.1) or some
subdirectory thereof (if you're using an older release). There are
some platforms such as OS X that put core files in a special directory
/core so check for that too.
If you're not finding any corefile then the most likely bet is that the
postmaster has been launched under "ulimit -c 0" which forbids dropping
a corefile. (This seems to be the default environment under many
Linuxen.) I'd suggest adding "ulimit -c unlimited" to the postmaster
start script you're using, restarting the postmaster, and repeating the
dump to cause the crash again.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, warren.little@meridiascapital.com
Subject: Re: Emergency - Need assistance
In-Reply-To: <12864.1136241261@sss.pgh.pa.us>
References: <1136228730.16094.12.camel@sharp> <11864.1136232604@sss.pgh.pa.us> <1136233928.16094.33.camel@sharp> <12399.1136237657@sss.pgh.pa.us> <1136240683.16094.40.camel@sharp> <12864.1136241261@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox