Re: Streaming base backups - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Streaming base backups
Date
Msg-id 4D31BEC6.7080804@enterprisedb.com
Whole thread Raw
In response to Re: Streaming base backups  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Streaming base backups  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 15.01.2011 17:30, Tom Lane wrote:
> 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.

No, they won't, if pg_base_backup() is called *after* getting the list 
of tablespaces.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Spread checkpoint sync
Next
From: Tom Lane
Date:
Subject: Re: Bug in pg_describe_object, patch v2