| 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(-)
| 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. |