From: | pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> |
---|---|
To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
Subject: | URGENT: where to find info about the pg structure |
Date: | 2003-05-29 14:06:05 |
Message-ID: | 3ED613CD.83533B0E@t1.unisoftbg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
I posted today message about pg globals directory corruption.
I am using pg 7.3 on linux with reiserfs.
My problem is where to find more info about the pg structure.
To this moment I created one new db with the same structure as my
original.
I was able to finf the filename of one from my tables into the new db.
Also I have this file from the corrupted system.
I stoped the db and make copy over the new file.
After bd start I am not able to any data in pg.
Pg report:
LOG: database system is shut down
LOG: database system was shut down at 2003-05-29 17:46:10 EEST
LOG: checkpoint record is at 25/2B043768
LOG: redo record is at 25/2B043768; undo record is at 0/0; shutdown
TRUE
LOG: next transaction id: 4607583; next oid: 52623925
LOG: database system is ready
PANIC: read of clog file 4, offset 196608 failed: Success
LOG: statement: vacuum full analyze verbose a_nomen;
LOG: server process (pid 1455) was terminated by signal 6
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing shared memory and
semaphores
LOG: database system was interrupted at 2003-05-29 17:49:18 EEST
LOG: checkpoint record is at 25/2B043768
LOG: redo record is at 25/2B043768; undo record is at 0/0; shutdown
TRUE
LOG: next transaction id: 4607583; next oid: 52623925
LOG: database system was not properly shut down; automatic recovery in
progress
FATAL: The database system is starting up
LOG: ReadRecord: record with zero length at 25/2B0437A8
LOG: redo is not required
LOG: database system is ready
LOG: smart shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2003-05-29 17:49:58 EEST
LOG: checkpoint record is at 25/2B0437E8
LOG: redo record is at 25/2B0437E8; undo record is at 0/0; shutdown
TRUE
LOG: next transaction id: 4607583; next oid: 52623925
LOG: database system is ready
Is it possible to replace the files with my "old" files and if yes how?
Any idea will help.
regards,
ivan.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-05-29 14:26:43 | Re: After VACUUM, statistics become skewed |
Previous Message | JJ McGrath | 2003-05-29 12:52:43 | unsubscribe |