Re: pg_dump gives segmentation fault and cores - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump gives segmentation fault and cores
Date
Msg-id 19805.1014786676@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump gives segmentation fault and cores  (Doug McNaught <doug@wireboard.com>)
List pgsql-general
Doug McNaught <doug@wireboard.com> writes:
> replogle992@hotmail.com (Andrew Replogle) writes:
>> when trying to run pg_dump dbname > dbname.db   it runs for a few
>> minutes then gives the following output as well as a core dump:

> You'll need to rebuild Postgres with debugging turned on, and get a
> backtrace from the core file (type 'bt' at the gdb prompt).

Another useful thing to do is to turn on query logging: do
    export PGOPTIONS="-d2"
(or equivalent csh syntax if you prefer a csh-type shell) before
you run pg_dump.  Then look in the postmaster log file to see the
queries pg_dump generated.  The last two or three queries before
the crash will be useful info.

> What version is this?

Also critical info...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dumpall storing multiple copies of DB's?
Next
From: Tom Lane
Date:
Subject: Re: configure --with-pam