Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 935C39FB34D for ; Mon, 26 Feb 2007 08:41:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 07236-06 for ; Mon, 26 Feb 2007 08:41:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 8F9BB9FB33D for ; Mon, 26 Feb 2007 08:41:48 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1HLfOw-0002eX-0I for pgsql-sql@postgresql.org; Mon, 26 Feb 2007 07:56:22 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 2328D4051; Mon, 26 Feb 2007 07:41:39 -0500 (EST) Date: Mon, 26 Feb 2007 07:41:39 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: pg_dump fails (timestamp out of range) Message-ID: <20070226124139.GA32438@phlogiston.dyndns.org> References: <45DD82AC.2030800@numerixtechnology.de> <5458.1172159013@sss.pgh.pa.us> <45E2BEE4.5090003@numerixtechnology.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <45E2BEE4.5090003@numerixtechnology.de> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/263 X-Sequence-Number: 27597 On Mon, Feb 26, 2007 at 11:05:08AM +0000, T E Schmitz wrote: > I can't thank you enough for the above advice. The test above identified > 3 records and once they were removed I was able to dump the DB. You'll be wanting to make sure your hardware is fixed after this, don't forget, or you'll end up in the same place next time. A -- Andrew Sullivan | ajs@crankycanuck.ca When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes