Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UB8p9-0000TZ-Qd for pgsql-admin@arkaria.postgresql.org; Thu, 28 Feb 2013 19:07:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UB8p9-0007Om-8I for pgsql-admin@arkaria.postgresql.org; Thu, 28 Feb 2013 19:07:23 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UB8p8-0007Og-GU for pgsql-admin@postgresql.org; Thu, 28 Feb 2013 19:07:22 +0000 Received: from [89.36.21.141] (helo=server.scorpionsoftware.ro) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UB8p6-0005co-5Q for pgsql-admin@postgresql.org; Thu, 28 Feb 2013 19:07:21 +0000 Received: from dyn-89.136.51.189.cj.upcnet.ro ([89.136.51.189]:60381 helo=[192.168.1.160]) by server.scorpionsoftware.ro with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.80) (envelope-from ) id 1UB8n1-0004Wj-SY for pgsql-admin@postgresql.org; Thu, 28 Feb 2013 21:05:11 +0200 Message-ID: <512FAA73.8000701@scorpionsoftware.ro> Date: Thu, 28 Feb 2013 21:05:23 +0200 From: Daniel Paval User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20120907 Thunderbird/15.0.1 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Data corruption / recover References: <512F3562.9060609@scorpionsoftware.ro> <4302.1362061275@sss.pgh.pa.us> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - server.scorpionsoftware.ro X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - scorpionsoftware.ro X-Get-Message-Sender-Via: server.scorpionsoftware.ro: authenticated_id: dani+scorpionsoftware.ro/only user confirmed/virtual account not confirmed X-Host-Lookup-Failed: Reverse DNS lookup failed for 89.36.21.141 (failed) X-Pg-Spam-Score: 1.6 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On 28.02.2013 18:48, Scott Marlowe wrote: > On Thu, Feb 28, 2013 at 7:21 AM, Tom Lane wrote: >> Daniel Paval writes: >>> We're dealing with the following situation (PG version is 7.4.30): >> 7.4? I sure hope you're going to migrate onto something less obsolete >> once you get out of this problem. In any still-in-support release >> series, autovacuum would have saved you from this. > Also don't later versions refuse to start in anything other than > single user mode once they get close to wrap around? > > Yes, I found out that newer versions play on the safe side and won't allow wrap-around at all. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin