Re: [GENERAL] pg_basebackup ----xlog-method=stream - Mailing list pgsql-general

From Ian Harding
Subject Re: [GENERAL] pg_basebackup ----xlog-method=stream
Date
Msg-id 8E472A27-3D2A-42AA-806D-FE648D2CADCB@gmail.com
Whole thread Raw
In response to Re: [GENERAL] pg_basebackup ----xlog-method=stream  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general

> On Apr 21, 2017, at 3:29 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
>
>> On Sat, Apr 22, 2017 at 3:02 AM, Ian Harding <harding.ian@gmail.com> wrote:
>> Am I misunderstanding how this works?  I have WAL archiving set up, so the
>> files are available, but I wanted them included in the backup.
>
> Please note that if you have a WAL archive available, you may not even
> need to have --xlog-method=stream, which is useful to have fully
> safe-contailed backups. For the error regarding the missing WAL
> segment, it could happen if Postgres completes two checkpoints when
> taking the backup. One thing that you could use is a replication slot
> that gives the guarantee that segments are retained. Those have been
> integrated in pg_basebackup with 9.6.

Yeah. I really want to use replication slots but put the server into production without setting the appropriate config
settings.I need to schedule some downtime for a restart.  

> --
> Michael


pgsql-general by date:

Previous
From: Cat
Date:
Subject: Re: [GENERAL] Recover PostgreSQL database folder data
Next
From: chiru r
Date:
Subject: [GENERAL] pg_basebackup issue