Re: Include WAL in base backup
Dimitri Fontaine <dimitri@2ndquadrant.fr>
From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Magnus Hagander <magnus@hagander.net>
Cc: Dimitri Fontaine <dimitri@2ndquadrant.fr>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-01-16T17:45:07Z
Lists: pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes: >> What if you start a concurrent process that begins streaming the WAL >> segments just before you start the backup, and you stop it after having >> stopped the backup. I would think that then, the local received files >> would be complete. We would only need a program able to stream the WAL >> segments and build WAL files from that… do you know about one? :) > > Sure, if you stream the backups "on the side", then you don't need > this feature. This is for "very simple filesystem backups", without > the need to set up streaming of archiving. What I meant is: why don't we provide an option to automate just that behavior in pg_basebackup? It looks like a fork() then calling code you already wrote. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support