Thanks Cliff. Somebody forwarded this directly to Josh and he was very
prompt in calling me back while I was trapped in a cell off meeting. By
the time I had gotten back with him. The client had found Irving
Popovetsky here locally and we hooked up and he made short work of
getting the database back up for us. I am now in the process of
documenting the process to transfer all of this information to the new
server. Thanks for the quick member response though! I couldn't have
done it without you!
markh
-----Original Message-----
From: Cliff Wells [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 17, 2006 8:25 PM
To: PDXLUG, a Portland Linux user group
Cc: helpdesk
Subject: Re: [PDXLUG] 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 & #orlug
_______________________________________________
PDXLUG (a Portland Linux user group) mailing list
[email protected]
http://lists.pdxlug.org/mailman/listinfo/pdxlug
IRC: irc.freenode.net #pdxlug & #orlug
