Message-ID: <946a9fd4468f8d72aa7629a51a6349caf35e8a50.camel@cybertec.at>
Subject: Re: The ability of postgres to determine loss of files of the main
 fork
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: Mon, 06 Oct 2025 14:07:47 +0200
In-Reply-To: 
 <CAKZiRmzGgOY5iQ=CFHJVE2df2Bz599bACqoWP3V_e-3Rw+XJhA@mail.gmail.com>
References: <013D63E2-5D75-492E-85FF-1D5CC0148C82@gmail.com>
	 <CAJ7c6TMYvYBQpgv8k+4QnajqPcroOzrj7d3snBBTKX4tHQfVYw@mail.gmail.com>
	 <499686.1759250489@sss.pgh.pa.us>
	 <68dcd1f2.df0a0220.3300c0.f7af@mx.google.com>
	 <CAKZiRmwHKY=KTjBEL3S2cVQpo1OjHyky4BdgJm4Hkv1-ig9PfQ@mail.gmail.com>
	 <CAJ7c6TMCyhX4Z7FrS=ORCcKS1F_iZzfUuQM3shx64WKynoxjsA@mail.gmail.com>
	 <CAKZiRmy0CK3m0-raCdTDELg0JjY7qAqzEN9P5n4N4wGw6ys4tw@mail.gmail.com>
	 <68dd1b79.170a0220.3c4175.198f@mx.google.com>
	 <CAKZiRmzGgOY5iQ=CFHJVE2df2Bz599bACqoWP3V_e-3Rw+XJhA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/946a9fd4468f8d72aa7629a51a6349caf35e8a50.camel%40cybertec.at>
Precedence: bulk

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