Re: is sync rep stalled?

On 04.10.2010 17:22, Fujii Masao wrote:
> If we make all the transactions wait until specified standbys have
> connected to the master, how do we take a base backup from the
> master for those standbys? We seem to be unable to do that because
> pg_start_backup also waits forever. Is this right?

Hmm, pg_start_backup() writes WAL, but it doesn't commit. Only a commit
needs to wait for acknowledgment from the standby, so 'wait forever'
behavior doesn't necessarily mean that you can't take a base backup. If
you run it outside a transaction you get an implicit commit, though,
which will wait, so you might need to do something odd like "begin;
select pg_start_backup(); rollback".

But I agree with Tom that as long as it's possible to change the
configuration on the fly, it's not a show-stopper if you can't take a
new base backup while the standby is disconnected.

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