Re: Streaming base backups

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: Magnus Hagander <magnus@hagander.net>, Fujii Masao <masao.fujii@gmail.com>, Cédric Villemain <cedric.villemain.debian@gmail.com>, Dimitri Fontaine <dimitri@2ndquadrant.fr>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-01-15T15:30:04Z
Lists: pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> BTW, I just spotted a small race condition between creating a new table 
> space and base backup. We take a snapshot of all the tablespaces in 
> pg_tblspc before calling pg_start_backup(). If someone creates a new 
> tablespace and puts some data in it in the window between base backup 
> acquiring the list tablespaces and starting the backup, the new 
> tablespace won't be included in the backup.

So what?  The needed actions will be covered by WAL replay.

			regards, tom lane