Re: File based Incremental backup v8 - Mailing list pgsql-hackers

From Andres Freund
Subject Re: File based Incremental backup v8
Date
Msg-id 20150129214351.GA24213@alap3.anarazel.de
Whole thread Raw
In response to Re: File based Incremental backup v8  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 2015-01-29 12:57:22 -0500, Robert Haas wrote:
> The issues here are similar to those in
> http://www.postgresql.org/message-id/20150120152819.GC24381@alap3.anarazel.de
> - basically, I think we need to make CREATE DATABASE and ALTER
> DATABASE .. SET TABLESPACE fully WAL-logged operations, or this is
> never going to work right.  If we're not going to allow that, we need
> to disallow hot backups while those operations are in progress.

Yea, the current way is just a hack from the dark ages. Which has some
advantages, true, but I don't think they outweight the disadvantages. I
hope to find time to develop a patch to make those properly WAL logged
(for master) sometime not too far away.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Small bug on CREATE EXTENSION pgq...
Next
From: Jim Nasby
Date:
Subject: Re: Providing catalog view to pg_hba.conf file - Patch submission