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 & #orlug