URGENT: pg_dump & Postgres 7.2b4 - Mailing list pgsql-general

From Christian Meunier
Subject URGENT: pg_dump & Postgres 7.2b4
Date
Msg-id a1kc2b$2m6h$1@news.tht.net
Whole thread Raw
List pgsql-general
Hi all, when i try to do a simple pg_dump i got the following errors:

2002-01-10 14:57:11 FATAL 2:  open of /usr/local/pgsql/data/pg_clog/0000
failed: No such file or directory
2002-01-10 14:57:11 DEBUG:  server process (pid 1201) exited with exit code
2
2002-01-10 14:57:11 DEBUG:  terminating any other active server processes
2002-01-10 14:57:11 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-01-10 14:57:11 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-01-10 14:57:11 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-01-10 14:57:11 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-01-10 14:57:11 DEBUG:  all server processes terminated; reinitializing
shared memory and semaphores
2002-01-10 14:57:11 DEBUG:  database system was interrupted at 2002-01-10
14:55:48 GMT
2002-01-10 14:57:11 DEBUG:  checkpoint record is at 0/1AD7A188
2002-01-10 14:57:11 DEBUG:  redo record is at 0/1AD75E88; undo record is at
0/0; shutdown FALSE
2002-01-10 14:57:11 DEBUG:  next transaction id: 2550628; next oid: 294388
2002-01-10 14:57:11 DEBUG:  database system was not properly shut down;
automatic recovery in progress
2002-01-10 14:57:11 DEBUG:  redo starts at 0/1AD75E88
2002-01-10 14:57:11 DEBUG:  ReadRecord: record with zero length at
0/1ADD14A8
2002-01-10 14:57:11 DEBUG:  redo done at 0/1ADD1484
2002-01-10 14:57:12 FATAL 1:  The database system is starting up
2002-01-10 14:57:12 FATAL 1:  The database system is starting up
2002-01-10 14:57:13 FATAL 1:  The database system is starting up
2002-01-10 14:57:13 FATAL 1:  The database system is starting up
2002-01-10 14:57:13 FATAL 1:  The database system is starting up
2002-01-10 14:57:13 FATAL 1:  The database system is starting up
2002-01-10 14:57:13 FATAL 1:  The database system is starting up
2002-01-10 14:57:13 DEBUG:  database system is ready
2002-01-10 14:57:14 ERROR:  Cannot insert a duplicate key into unique index
eq_profile_pkey
2002-01-10 14:57:36 ERROR:  Cannot insert a duplicate key into unique index
eq_profile_pkey
2002-01-10 14:57:57 ERROR:  Cannot insert a duplicate key into unique index
account_pkey
2002-01-10 14:58:18 ERROR:  Cannot insert a duplicate key into unique index
eq_profile_pkey
2002-01-10 14:58:44 ERROR:  Cannot insert a duplicate key into unique index
eq_profile_pkey

And in the console i got:

pg_dump: query to get data of sequence "account_num_seq" failed: FATAL 2:
open of /usr/local/pgsql/data/pg_clog/0000 failed: No such file or directory
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.

The only file i got in directory pg_clog is : 0002

Help plz.
Thx in advance.




pgsql-general by date:

Previous
From:
Date:
Subject: Re: Performance tips
Next
From: "Christian Meunier"
Date:
Subject: Re: URGENT: pg_dump & Postgres 7.2b4