Re: Add timeline to partial WAL segments - Mailing list pgsql-hackers

From David Steele
Subject Re: Add timeline to partial WAL segments
Date
Msg-id 5f261987-aa15-6921-d798-69a7b90e78c9@pgmasters.net
Whole thread Raw
In response to Re: Add timeline to partial WAL segments  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Add timeline to partial WAL segments
List pgsql-hackers
On 12/11/18 11:06 PM, Robert Haas wrote:
> On Wed, Dec 12, 2018 at 11:29 AM Michael Paquier <michael@paquier.xyz> wrote:
>> I really don't think that it is a good idea to link a future timeline
>> within a segment which includes in its name a direct reference to its
>> current timeline.  Also  I don't buy much the argument that those
>> segments are a nuisance as well all the time.  They may be for some
>> tools, however not for others depending on the archiving strategy
>> (distributed locations for example), and if they are a problem for your
>> deployments, why not just discarding them within the archive command and
>> be done with them?
> 
> -1.  Writing an archive_command already requires a PhD in
> PostgreSQL-ology.  The very last thing we should do is invent even
> more ways for an archive command to be subtly wrong.

The point here is to make archive commands simpler.  As it is, the
various backup tools are going to need to find ways to deal with the
problem, and each solution will be different.

The goal is to come up with a solution that works and that all archive
commands can use, rather than each one rolling their own solution.

-- 
-David
david@pgmasters.net


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Why not represent "never vacuumed" accurately wrt pg_class.relpages?
Next
From: Robert Haas
Date:
Subject: Re: Add timeline to partial WAL segments