Postgres Pro
Downloads
Home   >   mailing lists

Re: could not truncate directory "pg_subtrans": apparent wraparound - Mailing list pgsql-admin

From Simon Riggs
Subject Re: could not truncate directory "pg_subtrans": apparent wraparound
Date
Msg-id 1274730957.6203.527.camel@ebony
Whole thread Raw
In response to Re: could not truncate directory "pg_subtrans": apparent wraparound  (Mikko Partio <mpartio@gmail.com>)
Responses Re: could not truncate directory "pg_subtrans": apparent wraparound  (Mikko Partio <mpartio@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Josi Perez (3T Systems)"
Date:
Subject: Re: Trigger with dynamic SQL
Next
From: Samuel Stearns
Date:
Subject: transaction_timestamp()