| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | harding(dot)ian(at)gmail(dot)com |
| Cc: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_basebackup ----xlog-method=stream |
| Date: | 2017-04-21 22:29:25 |
| Message-ID: | CAB7nPqR8k7sqOko=6UZjADvEtturHTnws+oV7m=qAFO1nfO8CA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edson Lidorio | 2017-04-21 23:20:38 | Re: Recover PostgreSQL database folder data |
| Previous Message | Alan Hodgson | 2017-04-21 21:46:46 | Re: Recover PostgreSQL database folder data |