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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Tom K <tomkcpr(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: psql: FATAL: the database system is starting up
Date: 2019-06-01 20:11:17
Message-ID: 68710a45-7969-5a6c-f6c2-8b371b6c68b3@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-06-01 20:52:27 Re: psql: FATAL: the database system is starting up
Previous Message Tom K 2019-06-01 19:42:42 Re: psql: FATAL: the database system is starting up