pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_receivexlog only captures WAL data, not *.backup?
2+ messages / 2 participants
[nested] [flat]
* pg_receivexlog only captures WAL data, not *.backup?
@ 2018-01-11 02:24 Jerry Sievers <gsievers19@comcast.net>
2018-01-11 17:25 ` Re: pg_receivexlog only captures WAL data, not *.backup? Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 2+ messages in thread
From: Jerry Sievers @ 2018-01-11 02:24 UTC (permalink / raw)
To: pgsql-admin
This is on 9.6 and I have not tested on 10 yet.
The docs mention being able to use pg_receivexlog in stead of
archive_command as main backup method, I wonder how this is possible?
I did observe that no such *.backup file gets copied by pg_receivexlog
after the server was put in and taken out of backup mode.
It was my impression that *.backup files were required during PITR to
mark the point of consistency.
Is this not or no longer the case?
Or, I wonder if it depends on pg_basebackup being used w/one of the
options that captures all WAL as part of it?
Also, I did not (yet) test to see whether timeline *.history files get
copied if pg_receivexlog was pointed at a standby that was then
promoted.
Thanks for any insight.
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_receivexlog only captures WAL data, not *.backup?
2018-01-11 02:24 pg_receivexlog only captures WAL data, not *.backup? Jerry Sievers <gsievers19@comcast.net>
@ 2018-01-11 17:25 ` Magnus Hagander <magnus@hagander.net>
0 siblings, 0 replies; 2+ messages in thread
From: Magnus Hagander @ 2018-01-11 17:25 UTC (permalink / raw)
To: Jerry Sievers <gsievers19@comcast.net>; +Cc: pgsql-admin
On Thu, Jan 11, 2018 at 3:24 AM, Jerry Sievers <gsievers19@comcast.net>
wrote:
> This is on 9.6 and I have not tested on 10 yet.
>
> The docs mention being able to use pg_receivexlog in stead of
> archive_command as main backup method, I wonder how this is possible?
>
> I did observe that no such *.backup file gets copied by pg_receivexlog
> after the server was put in and taken out of backup mode.
>
> It was my impression that *.backup files were required during PITR to
> mark the point of consistency.
>
> Is this not or no longer the case?
>
> Or, I wonder if it depends on pg_basebackup being used w/one of the
> options that captures all WAL as part of it?
>
> Also, I did not (yet) test to see whether timeline *.history files get
> copied if pg_receivexlog was pointed at a standby that was then
> promoted.
Hi!
The .backup files should not be required for PITR. The .label file is
required, but that one is included as part of pg_basebackup (or need to be
included by any other tool you use to make the backup). The .backup file in
the log archive is not used by PostgreSQL.
The .history files, however, are required. And pg_receivexlog should copy
them as required automatically.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/;
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-01-11 17:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-01-11 02:24 pg_receivexlog only captures WAL data, not *.backup? Jerry Sievers <gsievers19@comcast.net>
2018-01-11 17:25 ` Magnus Hagander <magnus@hagander.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox