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