URGENT: pg_dump & Postgres 7.2b4
От | Christian Meunier |
---|---|
Тема | URGENT: pg_dump & Postgres 7.2b4 |
Дата | |
Msg-id | a1kc2b$2m6h$1@news.tht.net обсуждение исходный текст |
Список | 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 по дате отправления: