Re: psql: FATAL: the database system is starting up

Поиск
Список
Период
Сортировка
От Tom K
Тема Re: psql: FATAL: the database system is starting up
Дата
Msg-id CAE3EmBAhL+U85t_YoTbZUOqEzc8jjsKjVWtXCQPsS6ycQirOvg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql: FATAL: the database system is starting up  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: psql: FATAL: the database system is starting up  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general


On Sat, Jun 1, 2019 at 4:11 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 6/1/19 12:32 PM, Tom K wrote:
>
>

>
>     What if you move the recovery.conf file out?
>
>
> Will try.
>
>
>
>     The below looks like missing/corrupted/incorrect files. Hard to tell
>     without knowing what Patroni did?
>
>
> Storage disappeared from underneath these clusters.  The OS was of
> course still in memory making futile attempts to write to disk, which
> would never complete.
>
> My best guess is that Patroni or postgress was in the middle of some
> writes across the clusters when the failure occurred.

So to be clear all three clusters where writing to the same storage
medium and there was no WAL archiving to some other storage?

Yep, cheap LAB hardware with no power redundancy ( yet ) .  



>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: psql: FATAL: the database system is starting up
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: psql: FATAL: the database system is starting up