Re: pg_dump gives segmentation fault and cores

Doug McNaught <doug(at)wireboard(dot)com> writes:
> replogle992(at)hotmail(dot)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