Re: Postgres WAL Recovery Fails... And Then Works...

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Postgres WAL Recovery Fails... And Then Works...
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B0579983E@ntex2010a.host.magwien.gv.at
обсуждение исходный текст
Ответ на Postgres WAL Recovery Fails... And Then Works...  (Phil Monroe <phil@identified.com>)
Список pgsql-admin
Phil Monroe wrote:
> So we had to failover and do a full base backup to get our slave database back online and ran into a
> interesting scenario. After copying the data directory, setting up the recovery.conf, and starting the
> slave database, the database crashes while replaying xlogs. However, trying to start the database
> again, the database is able to replay xlogs farther than it initially got, but ultimately ended up
> failing out again. After starting the DB a third time, PostgreSQL replays even further and catches up
> to the master to start streaming replication. Is this common and or acceptable?

Certainly not acceptable.

Just checking: When you were "copying the data directory",
did you have online backup mode enabled?

Yours,
Laurenz Albe


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Rajagopalan, Jayashree"
Дата:
Сообщение: Casting bytea to varchar
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Casting bytea to varchar