Re: pg_dumpall won't work?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dumpall won't work?
Дата
Msg-id 8930.1014317906@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dumpall won't work?  (Joel Mc Graw <jmcgraw@databill.com>)
Список pgsql-admin
Joel Mc Graw <jmcgraw@databill.com> writes:
> Tom,  I'm afraid I'm not quite the guru I'd like to be; can you (or
> anyone) provide guidance on getting a "debugger backtrace from the
> segfault"?

Find the core file (if there isn't one, maybe you need "ulimit -c unlimited")
and do
    gdb /path/to/executable /path/to/corefile
    gdb> bt
    gdb> quit
Make sure you are selecting the executable that actually generated the
core dump.  It was less than clear to me from your report whether the
crash was in pg_dumpall, pg_dump (which it invokes), or on the backend
side.  On many platforms file(1) can tell you which program generated
a particular core dump.

BTW, did you say which platform and which PG version this is?

> The following shows the queries after exporting PGOPTIONS="-d2"

No, I meant the queries sent to the backend --- look in the postmaster
log.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Joel Mc Graw
Дата:
Сообщение: Re: pg_dumpall won't work?
Следующее
От: Pam Wampler
Дата:
Сообщение: Help on Trugger/Function