Re: could not truncate directory "pg_subtrans": apparent wraparound

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Mikko Partio <mpartio(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: could not truncate directory "pg_subtrans": apparent wraparound
Date: 2010-05-24 19:55:57
Message-ID: 1274730957.6203.527.camel@ebony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Samuel Stearns 2010-05-25 04:25:44 transaction_timestamp()
Previous Message Josi Perez (3T Systems) 2010-05-24 18:53:24 Re: Trigger with dynamic SQL