[Pgpool-general] difference between master and primary node in streaming mode
Jeff Frost
jeff at pgexperts.com
Wed Oct 5 18:38:38 UTC 2011
What's the difference between the master and primary node in streaming
replication mode?
Occasionally, in my testing, I see this:
Oct 5 11:36:08 31214-1-807393 pgpool[28871]: find_primary_node_repeatedly:
waiting for finding a primary node
Oct 5 11:36:08 31214-1-807393 pgpool[28871]: last message repeated 10 times
Oct 5 11:36:08 31214-1-807393 pgpool[28871]: find_primary_node: 0 node is standby
Oct 5 11:36:08 31214-1-807393 pgpool[28871]: last message repeated 10 times
Oct 5 11:36:08 31214-1-807393 pgpool[28871]: find_primary_node: primary node
id is 1
Oct 5 11:36:08 31214-1-807393 pgpool[28871]: failover: set new primary node: 1
Oct 5 11:36:08 31214-1-807393 pgpool[28871]: failover: set new master node: 0
Note that the primary and master are different. I understand that the primary
node is considered whichever node is not in recovery mode, but what is the master?
--
Jeff Frost <jeff at pgexperts.com>
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
FAX: 415-762-5122
http://www.pgexperts.com/
More information about the Pgpool-general
mailing list