Re: [RFC] What should we do for reliable WAL archiving?

From: "MauMau" <maumau307(at)gmail(dot)com>
To: "Michael Paquier" <michael(dot)paquier(at)gmail(dot)com>
Cc: "Mitsumasa KONDO" <kondo(dot)mitsumasa(at)gmail(dot)com>, "Fujii Masao" <masao(dot)fujii(at)gmail(dot)com>, "Robert Haas" <robertmhaas(at)gmail(dot)com>, "PostgreSQL mailing lists" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [RFC] What should we do for reliable WAL archiving?
Date: 2014-03-21 15:02:08
Message-ID: 6A638670F2644973B931E3F276CF2202@maumau
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

From: "Michael Paquier" <michael(dot)paquier(at)gmail(dot)com>
> On Fri, Mar 21, 2014 at 8:54 PM, MauMau <maumau307(at)gmail(dot)com> wrote:
>> * Create pg_copy in C so that it can be used on Windows as well as on
>> UNIX/Linux. It just copies one file. Its source code is located in
>> src/bin/pg_copy/. Please recommend a better name if you have one in
>> mind.
> I'd rather see that as a part of contrib/ if possible. Is there any
> portion of the code you have in mind that makes mandatory putting it
> in src/bin?

Archiving transaction logs reliably is a basic responsibility of DBMS, so I
think it should be treated as part of the core. It is not a desirable
feature but actually a mandatory one to persist transaction logs. Even if
it were a "better to have" feature, it can be put in the core like
pg_basebackup and pg_isready, which are not mandatory tools.

>> * Should I complete the work before 9.4 beta so that it will be available
>> starting with 9.4? I think so because it is a basic capability to
>> archive
>> transaction logs safely (although the time may not allow me to do this).
> Pursing efforts on a utility like that is worth the shot IMO (I would
> use it for sure if it has reliable cross-platform support to unify
> sets of replication scripts), but including it in 9.4 is out of scope.
> A saner target would be the 1st commit fest of 9.5.

OK, I don't mind if it should be targeted at 9.4 or 9.5. If someone wants
it for 9.4, I try to hurry.

Regards
MauMau

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message MauMau 2014-03-21 15:03:00 Re: [RFC] What should we do for reliable WAL archiving?
Previous Message Andrew Dunstan 2014-03-21 14:44:29 Re: QSoC proposal: Rewrite pg_dump and pg_restore