[pgpool-general: 2485] Re: native replication PITR problems
videanuadrian at yahoo.com
Sat Jan 25 04:07:08 JST 2014
Thanks, for the answer but I have a pgpool native replication setup (not a master/slave with streaming replication).
Are my assuptions valid in such a scenario ?
From: Tatsuo Ishii <ishii at postgresql.org>
To: videanuadrian at yahoo.com
Cc: pgpool-general at pgpool.net
Sent: Friday, January 24, 2014 12:47 AM
Subject: Re: [pgpool-general: 2477] Re: native replication PITR problems
This week I am busy with working on my job. I just want to give a
> Hi all,
> just some clarifications :
> So, what I understand from here is that when I perform online recovery I
> should stop the stand-by pgpool server.
> Also, on the primary server
> there should be no connections open left, and until the recovery is
> performed, no other connections will be opened.
Assuming you choose master/slave plus streaming replication mode,
no. The primary server can work as usual while performing the
> The entire cluster will
> be basically down when 2nd stage recovery process is running.
> Are these assumptions correct ?
Again if I can assume you choose master/slave plus streaming
replication mode, no.
First of all, you don't need to define 2nd stage recovery process. It
only needs for replication mode (replication_mode = on).
Also while doing recovery, pgpool-II happily accepts new connections
from clients and even executes DMLs, which will be sent to the primary
PostgreSQL. The modifications made to the database are recorded on the
WAL on the primary and will be forwarded to the standby which is being
recovered. Once the standby server boots up, it will replay the wal
log sent from the primary.
SRA OSS, Inc. Japan
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general