Re: Using pg_start_backup() and pg_stop_backup()

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using pg_start_backup() and pg_stop_backup()
Date: 2013-07-17 01:59:03
Message-ID: CAB7nPqQMLHntYi5k0nSsAUDhaPV1zrVdaGZrBEyorD09aJJQjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 17, 2013 at 10:49 AM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 7/16/2013 6:21 PM, David B Harris wrote:
>>
>> Actually though (if any PostgreSQL developers are paying attention), it
>> might be useful to have a new WAL segment-managing behaviour. With the
>> advent of the replication functionality (which is amazing stuff, thanks
>> so much), I'd expect fewer and fewer installations to use WAL archiving.
>> If WAL archiving is disabled, it might make sense for pg_start_backup()
>> to postpone the deletion of WAL segments until pg_stop_backup().
>
>
> WAL archiving has another completely different use case, which is PITR,
> Point In Time Recovery.
Yep, and it is thought as safer to *always* keep a WAL archive working
in parallel with replication. Just for safety.
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert James 2013-07-17 04:25:38 Parameter for query
Previous Message John R Pierce 2013-07-17 01:49:52 Re: Using pg_start_backup() and pg_stop_backup()