Skip site navigation (1) Skip section navigation (2)

Re: Problem with PITR Past Particular WAL File

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig McElroy <craig(dot)mcelroy(at)contegix(dot)com>
Cc: PostgreSQL Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problem with PITR Past Particular WAL File
Date: 2007-10-24 18:26:34
Message-ID: 10123.1193250394@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Craig McElroy <craig(dot)mcelroy(at)contegix(dot)com> writes:
>> Can you get a stack trace from the core dump reported here?

>   Certainly, how can that be obtained?

$ gdb /path/to/postgres-executable /path/to/core-file
gdb> bt
gdb> quit

If you don't find a corefile in $PGDATA (or wherever your system puts
core files) then you probably need to restart the postmaster with
"ulimit -c unlimited" to allow producing a core.

If the "bt" output is just numbers and no symbols then it won't be of
any use; in that case you'll need to find or build non-stripped Postgres
executables.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: frank asabereDate: 2007-10-24 19:08:19
Subject: l need help
Previous:From: Brad KingDate: 2007-10-24 16:52:02
Subject: Re: Partitioning and deadlocks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group