Search Postgresql Archives

Re: PGSQL Database Recovery in Portland Oregon Area needed ASAP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, May 16, 2006 at 09:53:54AM -0700, Mark Holm wrote:
> 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:

Very old database, consider upgrading.

> 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.

Make sure you have a physical backup. pg_resetxlog may get you far
enough to start the server. Them immediatly dump, destroy the cluster
and restore. pg_resetxlog solves some problems, but you can't guarentee
your integrity anymore...

Have a ncie day,
-- 
Martijn van Oosterhout   <kleptog@xxxxxxxxx>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux