| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
| Cc: | David Steele <david(at)pgmasters(dot)net>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Adam Brightwell <adam(dot)brightwell(at)crunchydata(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
| Subject: | Re: PATCH: Exclude temp relations from base backup |
| Date: | 2018-03-26 17:06:19 |
| Message-ID: | 20180326170619.GR24540@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Greetings,
* Teodor Sigaev (teodor(at)sigaev(dot)ru) wrote:
> Will autovacuum (or something else) complain about absense of relfile during
> orphan table deleting? I mean, you get a base backup without temp tables,
> then you try to run postgres on it and will it complain about existing
> record in pg_class and absence of corresponding relfile?
I would certainly hope not considering that's what happens during
regular crash recovery also, so if there's an issue with that, we'd have
a problem in released versions.
There's an independent discussion that was being had recently about how
to make sure those records in pg_class get cleaned up in a reasonable
timeframe and don't lead to problems with wrap-arounds, but that's a
different and pre-existing issue.
Thanks!
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Steele | 2018-03-26 17:08:50 | Re: PATCH: Exclude temp relations from base backup |
| Previous Message | Robert Haas | 2018-03-26 16:52:37 | Re: [HACKERS] MERGE SQL Statement for PG11 |