Re: [GENERAL] pg_basebackup ----xlog-method=stream
От | Ian Harding |
---|---|
Тема | Re: [GENERAL] pg_basebackup ----xlog-method=stream |
Дата | |
Msg-id | 8E472A27-3D2A-42AA-806D-FE648D2CADCB@gmail.com обсуждение исходный текст |
Ответ на | Re: [GENERAL] pg_basebackup ----xlog-method=stream (Michael Paquier <michael.paquier@gmail.com>) |
Список | 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 по дате отправления: