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

From Adrian Klaver
Subject Re: psql: FATAL: the database system is starting up
Date
Msg-id 68710a45-7969-5a6c-f6c2-8b371b6c68b3@aklaver.com
Whole thread Raw
In response to Re: psql: FATAL: the database system is starting up  (Tom K <tomkcpr@gmail.com>)
Responses Re: psql: FATAL: the database system is starting up
List 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Tom K
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