Re: restoreing dumps fail

On Lun 13 May 2002 23:34, Tom Lane wrote:
> =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin(at)bugs(dot)unl(dot)edu(dot)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(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------