PGSQL Database Recovery help needed

"Mark Holm" <[email protected]> Wed, 17 May 2006 10:53:49 -0700
Newsgroups gmane.org.user-groups.linux.pdxlug
Message-ID <4534BE485054BA4B95D3F3479C7B1BEE0EE5CD@infoarch-sbs.InfoArchInc.local>
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 ]=20
	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


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
Mark A. Holm President
InfoArch, Inc.=A0 =A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=A0=A0 =
=A0=A0=A0Cell:=A0=A0=A0(503) 750-9741
7456 SW Baseline, PMB#123.=A0=A0=A0=A0=A0=A0=A0=A0=A0Office: (503) =
943-3202
Hillsboro, OR =
97123=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0Fax:=A0=A0  (503) =
591-8584
http://www.infoarch.com=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0<mailto:markh@=
infoarch.com>=20
_______________________________________________
PDXLUG (a Portland Linux user group) mailing list
[email protected]
http://lists.pdxlug.org/mailman/listinfo/pdxlug
IRC: irc.freenode.net #pdxlug &amp; #orlug