Re: pg_restore stuck in a loop?

On Tue, 2005-04-26 at 23:22 -0400, Tom Lane wrote:
> Rod Taylor <pg@rbt.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 ()





--