On Mon, Apr 22, 2019 at 01:15:49PM -0400, Bruce Momjian wrote:
On Mon, Apr 22, 2019 at 01:11:22PM -0400, Robert Haas wrote:
On Mon, Apr 22, 2019 at 12:35 PM Bruce Momjian <br...@momjian.us> wrote:
> I assumed the modblock files would be stored in the WAL archive so some
> external tools could generate incremental backups using just the WAL
> files. I assumed they would also be sent to standby servers so
> incremental backups could be done on standby servers too.
Yeah, that's another possible approach. I am not sure what is best.
I am thinking you need to allow any of these, and putting the WAL files
in pg_wal and having them streamed and archived gives that flexibility.
I agree - this would be quite useful for the prefetching use case I've
already mentioned in my previous message.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
