Re: pg_basebackup ----xlog-method=stream

> On Apr 21, 2017, at 3:29 PM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com> wrote:
>
>> On Sat, Apr 22, 2017 at 3:02 AM, Ian Harding <harding(dot)ian(at)gmail(dot)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