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

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: could not truncate directory "pg_subtrans": apparent wraparound
Дата
Msg-id CA+TgmoaFEjr5zCosiQSJ+SfVbzBginiREW5TrZ1aVeSCxiEB3w@mail.gmail.com
обсуждение исходный текст
Ответ на could not truncate directory "pg_subtrans": apparent wraparound  (MirrorX <mirrorx@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: BUG #6317: sequence error for pg_dump
Следующее
От: John Lumby
Дата:
Сообщение: Re: LIKE predicate and ERROR: 42P22: could not determine which collation to use for string comparison - HINT: Use the COLLATE clause ...