From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | shanmugavel <shanmugavel_m(at)onwardgroup(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5437: Production db down |
Date: | 2010-04-23 17:45:57 |
Message-ID: | 4BD1DCD5.3020204@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
shanmugavel wrote:
> The following bug has been logged online:
>
> Bug reference: 5437
> Logged by: shanmugavel
> Email address: shanmugavel_m(at)onwardgroup(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2010-04-23 17:46:26 | Re: BUG #5437: Production db down |
Previous Message | shanmugavel | 2010-04-23 15:52:03 | BUG #5437: Production db down |