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

From Robert Haas
Subject Re: could not truncate directory "pg_subtrans": apparent wraparound
Date
Msg-id CA+TgmoaFEjr5zCosiQSJ+SfVbzBginiREW5TrZ1aVeSCxiEB3w@mail.gmail.com
Whole thread Raw
In response to could not truncate directory "pg_subtrans": apparent wraparound  (MirrorX <mirrorx@gmail.com>)
List pgsql-bugs
On Sun, Dec 4, 2011 at 7:27 AM, MirrorX <mirrorx@gmail.com> wrote:
> hello to all,
>
> i found this error in the logs on the hot_standby server. this error
> appeared only once a few days back and hasn't come up again. the version i
> am using is 9.0.5 and the primary was loaded by restoring dump files
> (previous version was 8.4.4). i have never switched to this server and i =
am
> using streaming replication. the activity of the primary is very low, it
> creates about 5-10 wal archives every day and has always been like that. =
the
> error does not appear on the primary.
>
> =A0if you need more details about the servers plz tell me and i will post
> them.any information that you may have is more than welcome. thx in advan=
ce

Could you send the output of pg_controldata on the standby, and also
the contents of pg_clog on that machine?

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #6317: sequence error for pg_dump
Next
From: John Lumby
Date:
Subject: Re: LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...