Horton

Re: The ability of postgres to determine loss of files of the main fork

Laurenz Albe <laurenz.albe@cybertec.at>

View thread
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Jakub Wartak <jakub.wartak@enterprisedb.com>, Michael Banck <mbanck@gmx.net>
Cc: Aleksander Alekseev <aleksander@tigerdata.com>, pgsql-hackers@lists.postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>, Frits Hoogland <frits.hoogland@gmail.com>
Date: 2025-10-06T12:07:47Z
Lists: pgsql-hackers 
On Mon, 2025-10-06 at 11:19 +0200, Jakub Wartak wrote:
> Anyway, I do not know if opening all the files on startup (or just
> crash-recovery?) is the proper way

I am not sure if you understand the problem at hand: how can you
tell that a segment of a relation is missing?  You have to know that
there should be a file before you can try to open it.

Yours,
Laurenz Albe