Re: pg_restore stuck in a loop?

On Tue, 2005-04-26 at 23:22 -0400, Tom Lane wrote:
> Rod Taylor <pg(at)rbt(dot)ca> writes:
> > I eventually clued in and made a TOC and removed all of the Slony items,
> > but I'm still curious to know what exactly pg_restore had been doing for
> > the last hour or so.
>
> You tell us ;-). You've got the test case, attach to it with a debugger
> and find out what it's doing.

I wasn't entirely sure how to "catch it in action" so I just used CTRL+C
to interrupt the pg_restore process, and got these as backtraces:

(gdb) backtrace
#0 0xb74b9589 in mremap () from /lib/tls/libc.so.6
#1 0xb744dc13 in mremap_chunk () from /lib/tls/libc.so.6
#2 0xb744dfd1 in realloc () from /lib/tls/libc.so.6
#3 0xb75e46b9 in enlargePQExpBuffer ()
from /home/rbt/pg8/lib/libpq.so.4
#4 0xb75e481f in appendPQExpBufferChar ()
from /home/rbt/pg8/lib/libpq.so.4
#5 0x0804efe3 in _sendSQLLine ()
#6 0x0804f2bd in ExecuteSqlCommandBuf ()
#7 0x0805019e in _PrintData ()
#8 0x0804fee5 in _PrintTocData ()
#9 0x0804aba2 in RestoreArchive ()
#10 0x0804a525 in main ()

(gdb) backtrace
#0 0xb75e465e in enlargePQExpBuffer ()
from /home/rbt/pg8/lib/libpq.so.4
#1 0xb75e481f in appendPQExpBufferChar ()
from /home/rbt/pg8/lib/libpq.so.4
#2 0x0804efe3 in _sendSQLLine ()
#3 0x0804f2bd in ExecuteSqlCommandBuf ()
#4 0x0805019e in _PrintData ()
#5 0x0804fee5 in _PrintTocData ()
#6 0x0804aba2 in RestoreArchive ()
#7 0x0804a525 in main ()

(gdb) backtrace
#0 0xb75e4800 in appendPQExpBufferChar ()
from /home/rbt/pg8/lib/libpq.so.4
#1 0x0804efe3 in _sendSQLLine ()
#2 0x0804f2bd in ExecuteSqlCommandBuf ()
#3 0x0805019e in _PrintData ()
#4 0x0804fee5 in _PrintTocData ()
#5 0x0804aba2 in RestoreArchive ()
#6 0x0804a525 in main ()

--