Обсуждение: could not truncate directory "pg_subtrans": apparent wraparound

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

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/could-not-truncate-directory-pg-subtrans-apparent-wraparound-tp5046156p5046156.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

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