Re: restoreing dumps fail

On Mar 14 May 2002 10:58, Tom Lane wrote:
> =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin(at)bugs(dot)unl(dot)edu(dot)ar> writes:
> > 2002-05-14 10:23:36 DEBUG: child process (pid 15137) was terminated by
> > signal 10
>
> Hmm, apparently a bus error?
>
> > About the trace of the core, first I don't know exactly what to do, and
> > second, I can't find a core file (or does it have another name?)
>
> It should be named core (or some variant; some platforms include the PID
> or the program name, but pretty much everybody includes "core" in the
> name). And it will definitely be located in $PGDATA/base/yourdbnumber/.
>
> If you don't see one there then you probably started the postmaster with
> ulimit -c 0. Change to ulimit -c unlimited and try again.
>
> Once you get a core do
> gdb $INSTALL/bin/postgres $PGDATA/base/yourdbnumber/core
> gdb> bt

(gdb) bt
#0 0xff030b64 in __do_global_dtors_aux () from
/dbs/postgres/lib/array_iterator.so
#1 0xff030af8 in _fini () from /dbs/postgres/lib/array_iterator.so
#2 0xff3b9f5c in ?? ()
#3 0xff0a00d0 in _exithandle () from /usr/lib/libc.so.1
#4 0xff116814 in exit () from /usr/lib/libc.so.1
#5 0x1bea40 in proc_exit (code=0) at ipc.c:155
#6 0x1d69c8 in PostgresMain (argc=5, argv=0xffbef1e8, username=0x46d319
"postgres") at postgres.c:1951
#7 0x197df0 in DoBackend (port=0x46d1e8) at postmaster.c:2243
#8 0x197288 in BackendStartup (port=0x46d1e8) at postmaster.c:1874
#9 0x1957dc in ServerLoop () at postmaster.c:977
#10 0x195058 in PostmasterMain (argc=3, argv=0x455fb8) at postmaster.c:771
#11 0x1501fc in main (argc=3, argv=0xffbefc9c) at main.c:206
(gdb)

Could it be a problem with array_iterator.so???

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------