[pgpool-general: 2486] Re: Help error code e1012 on pgpool II 3.3.0 while clicking Recovery button
jeff at pgexperts.com
Sat Jan 25 05:17:11 JST 2014
On 01/23/14 20:30, Syed Irfan wrote:
> rsync -C -a -c --delete --exclude postgresql.conf --exclude postmaster.pid \
> --exclude postmaster.opts --exclude pg_log \
> --exclude recovery.conf --exclude recovery.done \
> --exclude pg_xlog \
> $master_db_cluster/ $recovery_node_host_name:$recovery_db_cluster
So, is the $recovery_db_cluster on the replica node empty when the base backup
starts? It seems like it might have had some WAL files in it from a previous
I think because you're excluding pg_xlog, rsync doesn't process the --deletes
on it, so you need to make sure and clean it out on the replica if there were
any existing WAL files before starting postgres.
Jeff Frost <jeff at pgexperts.com>
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general