pgsql: pageinspect: Reject access to temp and unlogged relations during

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: pageinspect: Reject access to temp and unlogged relations during
Date: 2026-11-09 06:47:23
Message-ID: E1xQJA3-00000000nAL-3Q0i@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

pageinspect: Reject access to temp and unlogged relations during recovery

Unlogged and temporary relations have no data on a standby, except for
the init fork of an unlogged relation. Attempting to use the functions
of pageinspect for such cases failed with the following ERROR:

ERROR: could not open file "base/MMM/NNN": No such file or directory

Such attempts are now blocked. The module already prevented the access
to temporary tables from other sessions. This check is moved into a new
common routine, merged with the new check for temp/unlogged tables at
recovery.

Reported-by: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
Author: Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>
Author: Kirill Reshke <reshkekirill(at)gmail(dot)com>
Author: Surya Poondla <suryapoondla4(at)gmail(dot)com>
Reviewed-by: Michael Paquier <michael(at)paquier(dot)xyz>
Discussion: https://postgr.es/m/82ba0876-6127-4770-b900-aa1bd52abfed@uni-muenster.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/553262aff40d34711e04e989e91d1da430589822

Modified Files
--------------
contrib/pageinspect/btreefuncs.c | 20 ++------------------
contrib/pageinspect/hashfuncs.c | 5 +----
contrib/pageinspect/pageinspect.h | 2 ++
contrib/pageinspect/rawpage.c | 39 ++++++++++++++++++++++++++++++---------
4 files changed, 35 insertions(+), 31 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2026-11-09 08:05:21 pgsql: pgstattuple: Reject unlogged and temporary relations during reco
Previous Message Tom Lane 2026-11-08 21:41:45 pgsql: Release notes for 18.7, 17.12, 16.16, 15.20, 14.25.