Re: psql: FATAL: the database system is starting up - Mailing list pgsql-general

From Tom K
Subject Re: psql: FATAL: the database system is starting up
Date
Msg-id CAE3EmBAhL+U85t_YoTbZUOqEzc8jjsKjVWtXCQPsS6ycQirOvg@mail.gmail.com
Whole thread Raw
In response to Re: psql: FATAL: the database system is starting up  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: psql: FATAL: the database system is starting up
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: psql: FATAL: the database system is starting up
Next
From: Adrian Klaver
Date:
Subject: Re: psql: FATAL: the database system is starting up