X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1764B9FB56D; Thu, 18 May 2006 03:01:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 11280-02-5; Thu, 18 May 2006 03:01:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from svana.org (svana.org [125.62.94.225]) by postgresql.org (Postfix) with ESMTP id 6A1979FB660; Thu, 18 May 2006 02:39:47 -0300 (ADT) Received: from kleptog by svana.org with local (Exim 4.50) id 1FgbEf-00008U-8x; Thu, 18 May 2006 15:39:45 +1000 Date: Thu, 18 May 2006 07:39:45 +0200 From: Martijn van Oosterhout To: Mark Holm Cc: pgsql-jobs@postgresql.org, pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] PGSQL Database Recovery in Portland Oregon Area needed ASAP Message-ID: <20060518053945.GB32755@svana.org> Reply-To: Martijn van Oosterhout Mail-Followup-To: Mark Holm , pgsql-jobs@postgresql.org, pgsql-admin@postgresql.org, pgsql-general@postgresql.org References: <4534BE485054BA4B95D3F3479C7B1BEE0EE5AF@infoarch-sbs.InfoArchInc.local> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="XF85m9dhOBO43t/C" Content-Disposition: inline In-Reply-To: <4534BE485054BA4B95D3F3479C7B1BEE0EE5AF@infoarch-sbs.InfoArchInc.local> X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6 X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522 48A7 6394 F08A 0DC6 7BE6 X-PGP-Key-URL: User-Agent: Mutt/1.5.9i X-SA-Exim-Connect-IP: X-SA-Exim-Mail-From: kleptog@svana.org X-SA-Exim-Scanned: No (on svana.org); SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/256 X-Sequence-Number: 21788 --XF85m9dhOBO43t/C Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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, --=20 Martijn van Oosterhout http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to l= itigate. --XF85m9dhOBO43t/C Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFEbAihIB7bNG8LQkwRAlx5AJ0ftYn2p4L/K/k7G3M+3663d9GOoACdHYei d5fJDeaYaHGE/clP+WPmMMo= =n5dq -----END PGP SIGNATURE----- --XF85m9dhOBO43t/C--