Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 181BE632DC4 for ; Mon, 24 May 2010 16:56:10 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 00689-05 for ; Mon, 24 May 2010 19:56:02 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail148102.authsmtp.net (outmail148102.authsmtp.net [62.13.148.102]) by mail.postgresql.org (Postfix) with ESMTP id 0736863249C for ; Mon, 24 May 2010 16:56:01 -0300 (ADT) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt7.authsmtp.com (8.14.2/8.14.2) with ESMTP id o4OJtxK4036168; Mon, 24 May 2010 20:55:59 +0100 (BST) Received: from [192.168.0.2] (88-110-191-21.dynamic.dsl.as9105.com [88.110.191.21]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id o4OJtuc7046484; Mon, 24 May 2010 20:55:56 +0100 (BST) Subject: Re: could not truncate directory "pg_subtrans": apparent wraparound From: Simon Riggs To: Mikko Partio Cc: Tom Lane , pgsql-admin@postgresql.org In-Reply-To: References: <18038.1274637760@sss.pgh.pa.us> Content-Type: text/plain Date: Mon, 24 May 2010 20:55:57 +0100 Message-Id: <1274730957.6203.527.camel@ebony> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1 Content-Transfer-Encoding: 7bit X-Server-Quench: 5e3885ef-676e-11df-80b9-0022640b883e X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFagFbYFhI HGQLWlREUl17XGZ/ bgwfZQ1DY0tOQQRj UVZLQ01XHAJ3AVJe AmFkFlwhcAVCfnp4 YQhhWXBeEkEvdk51 RxsCCGsBYzJ9aWFL Bl1Qd1FdbQNKfB1D blAtXHsONCtlM3Bw LCYfGhEXCH1ULzlR TkkLKk5aXVwWGDU1 Wx1KETQ1EEYZQD8i Z1Y+JWkHAUwNKEw0 KhFzEVsAKxYIBwtC VyMFHzVQP1AbQDct AWsA X-Authentic-SMTP: 61633235383639.1015:706/Kp X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201005/226 X-Sequence-Number: 34699 On Mon, 2010-05-24 at 08:46 +0300, Mikko Partio wrote: > It was freshly initdb'd with beta1 binaries, the contents were loded > from a pg_dump file. The number of transactions is very small, we're > talking about thousands (not billions). This database is the master of > a hot standby installation, if that matters. Have you ever performed a switchover operation? If you've never run an extended recovery on that server, its less likely to be anything HS related. Are you running any special hot standby parameters? -- Simon Riggs www.2ndQuadrant.com