PITR and Temp Tables

From: Huan Ruan <leohuanruan(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: PITR and Temp Tables
Date: 2022-04-20 12:17:32
Message-ID: CAGgcTZtrBfPGXKwsPwK9JKNJWHs5c-a2HmNubsAi5gFUFEYqKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

Let's say at T0 a database has N session based temp tables. They would have
corresponding records in the catalog tables like pg_class and pg_attribute
that are visible to other sessions.

At T1, I do a PITR to T0. That recovered database should not have those
temp tables because the sessions they were created in are not present. My
question is what events trigger the deletion of those temp tables' catalog
records (e.g. pg_class and pg_attribute etc.) in the recovered database?

Thanks
Huan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick FICHE 2022-04-20 12:45:36 RE: PITR and Temp Tables
Previous Message Thomas, Richard 2022-04-20 08:06:41 RE: PostgreSQL 10.20 crashes / Antivirus