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

On Sun, Dec 4, 2011 at 7:27 AM, MirrorX <mirrorx(at)gmail(dot)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.
>
>  if 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 advance

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

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