shanmugavel wrote:
The following bug has been logged online:
Bug reference: 5437
Logged by: shanmugavel
Email address: shanmugave...@onwardgroup.com
PostgreSQL version: 8.3
Operating system: linux RHEL 5
Description: Production db down
Details:
Hi,
i'm shanmugavel I'm oracle dba now i handle the postgressql db. now i face
the problem
how can i resolve that the problem
LOG: database system was shut down at 2007-05-14 19:47:51 BST
LOG: invalid magic number 000 in log file 0, segment 0, offset 0
LOG: invalid primary checkpoint record
LOG: invalid magic number 000 in log file 0, segment 0, offset 0
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 9590) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
what sub-version of 8.3.x is this ?
this database was shut down 4 years ago and just now restarted? !?
thats odd.
frankly, it looks like the file system holding $PGDATA got seriously
stepped on and multiple database files are corrupted. got any backups?
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
