[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