Re: PATCH: Exclude temp relations from base backup - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: PATCH: Exclude temp relations from base backup
Date
Msg-id 2d998e91-585d-29c2-b3bf-14ff0ec14da9@sigaev.ru
Whole thread Raw
In response to Re: PATCH: Exclude temp relations from base backup  (David Steele <david@pgmasters.net>)
List pgsql-hackers
Thank you, pushed

David Steele wrote:
> On 3/26/18 1:06 PM, Stephen Frost wrote:
>>
>> * Teodor Sigaev (teodor@sigaev.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.
> 
> Agreed.  The logic for pg_basebackup was modeled off RemovePgTempFiles()
> which is called at postmaster start.  We are just doing the cleanup in
> advance (in the backup only, of course).
> 
> Thanks,
> 

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/


pgsql-hackers by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: Vacuum: allow usage of more than 1GB of work mem
Next
From: Pavan Deolasee
Date:
Subject: Re: [HACKERS] A design for amcheck heapam verification