Re: PATCH: Exclude unlogged tables from base backups - Mailing list pgsql-hackers

From Andres Freund
Subject Re: PATCH: Exclude unlogged tables from base backups
Date
Msg-id 20171212233348.2u2yuyv7o5guuilc@alap3.anarazel.de
Whole thread Raw
In response to Re: PATCH: Exclude unlogged tables from base backups  (David Steele <david@pgmasters.net>)
Responses Re: PATCH: Exclude unlogged tables from base backups
List pgsql-hackers
Hi,

On 2017-12-12 18:30:47 -0500, David Steele wrote:
> > If we had a way to prevent relfilenode reuse across multiple checkpoints
> > this'd be easier, although ALTER TABLE SET UNLOGGED still'd complicate.
> 
> Or error the backup if there is wraparound?

That seems entirely unacceptable to me. On a machine with lots of
toasting etc going on an oid wraparound doesn't take a long time. We've
only one oid counter for all tables, and relfilenodes are inferred from
that ....

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: Re: PATCH: Exclude unlogged tables from base backups
Next
From: David Steele
Date:
Subject: Re: PATCH: Exclude unlogged tables from base backups