Re: restoreing dumps fail

On Lun 13 May 2002 23:34, Tom Lane wrote:
> =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin@bugs.unl.edu.ar> writes:
> > I'm trying to upgrade from 7.1.3 to 7.2.1 and after makeing a dump,
> > installing the new version (7.2.1) making the initdb as postgres, when I
> > try to dump all the data back to the database, and after some dump the
> > backend dies:
> >
> > NOTICE:  Message from PostgreSQL backend:
> >         The Postmaster has informed me that some other backend
> >         died abnormally and possibly corrupted shared memory.
>
> Oh?  What's in the postmaster log?  Can you get a stack trace from
> the core file that the crashed backend left?

OK. I installed a seperated postgres server and put it to listen in port
15432. I tried to do a restore and got the same error.

This what the errors say:

2002-05-14 10:23:36 DEBUG:  connection: host=[local] user=martin
database=webunl
/dbs/postgres.new/bin/postmaster child[15138]: starting with (postgres -d2
-v131072 -p webunl )
2002-05-14 10:23:36 DEBUG:  InitPostgres
2002-05-14 10:23:36 DEBUG:  StartTransactionCommand
2002-05-14 10:23:36 DEBUG:  query: select getdatabaseencoding()
2002-05-14 10:23:36 DEBUG:  ProcessQuery
2002-05-14 10:23:36 DEBUG:  CommitTransactionCommand
2002-05-14 10:23:36 DEBUG:  StartTransactionCommand
2002-05-14 10:23:36 DEBUG:  query: SELECT usesuper FROM pg_user WHERE usename
= 'martin'
2002-05-14 10:23:36 DEBUG:  ProcessQuery
2002-05-14 10:23:36 DEBUG:  CommitTransactionCommand
2002-05-14 10:23:36 DEBUG:  StartTransactionCommand
2002-05-14 10:23:36 DEBUG:  query: CREATE SEQUENCE "facultad_id_fac_seq" start
1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
2002-05-14 10:23:36 DEBUG:  ProcessUtility: CREATE SEQUENCE
"facultad_id_fac_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1
cache 1 ;
2002-05-14 10:23:36 DEBUG:  INSERT @ 0/22CC90: prev 0/22CC68; xprev 0/0; xid
427; bkpb 1: Heap - insert: node 16893/1259; tid 1/11
2002-05-14 10:23:36 DEBUG:  INSERT @ 0/22ECF0: prev 0/22CC90; xprev 0/22CC90;
xid 427; bkpb 1: Btree - insert: node 16893/16429; tid 1/1
2002-05-14 10:23:36 DEBUG:  INSERT @ 0/230D50: prev 0/22ECF0; xprev 0/22ECF0;
xid 427; bkpb 1: Btree - insert: node 16893/16428; tid 1/102
2002-05-14 10:23:36 DEBUG:  proc_exit(0)
2002-05-14 10:23:36 DEBUG:  shmem_exit(0)
2002-05-14 10:23:36 DEBUG:  exit(0)
2002-05-14 10:23:36 DEBUG:  reaping dead processes
2002-05-14 10:23:36 DEBUG:  child process (pid 15137) was terminated by signal
10
2002-05-14 10:23:36 DEBUG:  server process (pid 15137) was terminated by
signal 10
2002-05-14 10:23:36 DEBUG:  terminating any other active server processes
2002-05-14 10:23:36 DEBUG:  CleanupProc: sending SIGQUIT to process 15138
2002-05-14 10:23:36 NOTICE:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend
        died abnormally and possibly corrupted shared memory.
        I have rolled back the current transaction and am
        going to terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.
2002-05-14 10:23:36 DEBUG:  reaping dead processes
2002-05-14 10:23:36 DEBUG:  child process (pid 15138) exited with exit code 1
2002-05-14 10:23:36 DEBUG:  all server processes terminated; reinitializing
shared memory and semaphores
2002-05-14 10:23:36 DEBUG:  shmem_exit(0)
invoking IpcMemoryCreate(size=3563520)
2002-05-14 10:23:36 DEBUG:  database system was interrupted at 2002-05-14
10:22:27 GMT
2002-05-14 10:23:36 DEBUG:  checkpoint record is at 0/113640
2002-05-14 10:23:36 DEBUG:  redo record is at 0/113640; undo record is at 0/0;
shutdown TRUE
2002-05-14 10:23:36 DEBUG:  next transaction id: 89; next oid: 16556
2002-05-14 10:23:36 DEBUG:  database system was not properly shut down;
automatic recovery in progress


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?)

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