Hello again! Just to summarise it:
The scripts
pgpool_remote_start,
recovery_1st_stage_command = 'copy-base-backup' and
recovery_2nd_stage_command = 'pgpool_recovery_pitr'
- must reside in the datadir of all backends
- get the parameters
DATA=$1
RECOVERY_TARGET=$2
RECOVERY_DATA=$3
- are called on some master node that is known to pgpool
The whole recovery process done by
- manually issue pcp_recovery_node
- pgpool executes CHECKPOINT on a master node
- pgpool executes SELECT pgpool_recovery('recovery-script,'target','PGDATA')"
on a master node
- This calls copy-base-backup
- UNCLEAR: This also calls pgpool_recovery_pitr?
- After that pgpool_remote_start is called by pgpool on master
- Then postgres does PITR
- Then the recovered postgres-server accepts connections again
UNCLEAR: -> How does pgpool detect when the postgresql-server is available
again?
- Then it is attached to the cluster again
- normal operation continues, all databases are accessable again
Is that correct so far?
And can you clearify the two unclear points?
Sincerly
Nico
--
Think about Free and Open Source Software (FOSS).
http://nico.schottelius.org/documentations/foss/the-term-foss/
PGP: BFE4 C736 ABE5 406F 8F42 F7CF B8BE F92A 9885 188C
signature.asc
Description: Digital signature
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
