From: | "Mark Holm" <markh(at)infoarch(dot)com> |
---|---|
To: | <pgsql-jobs(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | PGSQL Database Recovery in Portland Oregon Area needed ASAP |
Date: | 2006-05-16 16:53:54 |
Message-ID: | 4534BE485054BA4B95D3F3479C7B1BEE0EE5AF@infoarch-sbs.InfoArchInc.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
I have a client that is running an older version of Lyris List Manager against PostGres 7.1.2, that has crashed their database beyond my ability to recover it. The error that I am getting when we try and restart the database is:
/etc/init.d/postgresql start
Starting postgresql service: postmaster successfully started
DEBUG: database system was interrupted being in recovery at 2006-05-15 14:01:54 PDT
This propably means that some data blocks are corrupted
and you will have to use last backup for recovery.
DEBUG: CheckPoint record at (230, 4199276628)
DEBUG: Redo record at (230, 4199276628); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 159854941; NextOid: 34688714
DEBUG: database system was not properly shut down; automatic recovery in progress...
DEBUG: redo starts at (230, 4199276692)
[ OK ]
FATAL 2: btree_split_redo: uninitialized next right page
/usr/bin/postmaster: Startup proc 30311 exited with status 512 - abort
I have gone through the stuff on-line concerning this error and attempted to reinitialize the database and restore the night before's backup, but apparently the backups were not quite setup correctly as I cannot get a valid restore either. I am out of my depth on this one and am willing to contract somebody to help get this database back on-line again ASAP, as the client is getting frantic. If you have proven experience doing this sort of recovery, please contact me at the number or email address below. I am not a member of the lists, so please contact me directly. Rates are negotiable, but I will have to clear them with client before we proceed.
markh
====================================================
Mark A. Holm President
InfoArch, Inc. Cell: (503) 750-9741
7456 SW Baseline, PMB#123. Office: (503) 943-3202
Hillsboro, OR 97123 Fax: (503) 591-8584
http://www.infoarch.com <BLOCKED::http://www.infoarch.com /> <mailto:markh(at)infoarch(dot)com <BLOCKED::mailto:markh(at)infoarch(dot)com> >
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Hoover | 2006-05-16 17:27:07 | Autovacuum Question |
Previous Message | Andy Shellam | 2006-05-16 16:18:28 | Re: reg:Query |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-16 17:01:51 | Re: Weird ..... (a=1 or a=2) <> (a=2 or a=1) |
Previous Message | Rafael Martinez | 2006-05-16 16:53:41 | Re: Weird ..... (a=1 or a=2) <> (a=2 or a=1) |