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 <[email protected]>
Author: Jim Jones <[email protected]>
Author: Kirill Reshke <[email protected]>
Author: Surya Poondla <[email protected]>
Reviewed-by: Michael Paquier <[email protected]>
Discussion: 
https://postgr.es/m/[email protected]

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

Reply via email to