Re: PGSQL Database Recovery help needed

Joshua Drake at commandprompt.com is actually pretty good at PostgreSQL
database recovery.

[email protected]

Regards,
Cliff

On Wed, 2006-05-17 at 10:53 -0700, Mark Holm wrote:
> Does anybody here know of a good PostGres person in the area that knows database recovery on older versions?
> 
> 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. Rates are negotiable, but I will have to clear them with client before we proceed. They are also working on their end to find somebody as well.
> 
> Any help or pointers that anybody can give me would be greatly appreciated.
> 
> 	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            <mailto:[email protected]> 
> _______________________________________________
> PDXLUG (a Portland Linux user group) mailing list
> [email protected]
> http://lists.pdxlug.org/mailman/listinfo/pdxlug
> IRC: irc.freenode.net #pdxlug &amp; #orlug

_______________________________________________
PDXLUG (a Portland Linux user group) mailing list
[email protected]
http://lists.pdxlug.org/mailman/listinfo/pdxlug
IRC: irc.freenode.net #pdxlug &amp; #orlug