[pgpool-general: 8681] Re: How does pgpool ensure data consistency during a replica's recovery 1st stage?

[Tatsuo Ishii]

> I noticed " /etc/pgpool-II/recovery_1st_stage.sample
> <https://git.postgresql.org/gitweb/?p=pgpool2.git;a=blob_plain;f=src/sample/scripts/recovery_1st_stage.sample;hb=refs/heads/master>
> "
> 
> uses rsync to copy any different files that master has but the replica does
> not.

? the script above does not use rsync.

> What would happen as data in master is changed during this copy process?
> Will the copy fail to capture changes? (i.e. data modification).

PostgreSQL assumes that any physical copy tool does not capture
changes. The change set would be recorded in WAL and replayed later
on.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp