Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 32B049FB3AD
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 26 Feb 2007 08:52:51 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024)
	with ESMTP id 62053-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 26 Feb 2007 08:52:43 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from zebedee.cranntara.net (zebedee.cranntara.net [91.186.7.79])
	by postgresql.org (Postfix) with ESMTP id 046BA9FB56E
	for <pgsql-sql@postgresql.org>; Mon, 26 Feb 2007 08:52:48 -0400 (AST)
Received: from dial-dynamic-62-69-37-180.surfdial.murphx.net ([62.69.37.180]
	helo=bolek.coachhouse)
	by zebedee.cranntara.net with esmtpsa (TLS-1.0:RSA_AES_256_CBC_SHA1:32)
	(Exim 4.62) (envelope-from <mailreg@numerixtechnology.de>)
	id 1HLfLP-0000j7-TV; Mon, 26 Feb 2007 12:52:45 +0000
Received: from [192.168.0.32] (helo=[192.168.0.32])
	by bolek.coachhouse with esmtp (Exim 4.50)
	id 1HLfLE-00049N-Pb; Mon, 26 Feb 2007 12:52:32 +0000
Message-ID: <45E2D810.4030100@numerixtechnology.de>
Date: Mon, 26 Feb 2007 12:52:32 +0000
From: T E Schmitz <mailreg@numerixtechnology.de>
Reply-To: mailreg@numerixtechnology.de
User-Agent: Debian Thunderbird 1.0.7 (X11/20051017)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Andrew Sullivan <ajs@crankycanuck.ca>
CC: pgsql-sql@postgresql.org
Subject: Re: pg_dump fails (timestamp out of range)
References: <45DD82AC.2030800@numerixtechnology.de>
	<5458.1172159013@sss.pgh.pa.us>
	<45E2BEE4.5090003@numerixtechnology.de>
	<20070226124139.GA32438@phlogiston.dyndns.org>
In-Reply-To: <20070226124139.GA32438@phlogiston.dyndns.org>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.186 tagged_above=0 required=5 tests=AWL, BAYES_50,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200702/264
X-Sequence-Number: 27598

Andrew Sullivan wrote:
> 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.

This was the last step to get rid of the darned machine. Everything else 
had already been moved over to the new server. Wish I'd posted a week 
earlier; that would have saved me a month's rent.

-- 


Regards,

Tarlika Elisabeth Schmitz