bp=# select * from _replicatename.sl_set;

  set_id | set_origin | set_locked |    set_comment
--------+------------+------------+--------------------
       1 |          1 |            | bp customer
       2 |          1 |            | bp statistics

Look at the set_origin column - that gives you the master node for that 
set.

You really want to be asking which node does that set data originate from.

Think in terms of sets and not servers...

John

Ryan Suarez wrote:
> Greetings,
> 
> How do I query the slony replication system to determine which node is 
> the master?
> I'm using slony 1.1.5, postgres 7.4.7, and debian sarge.
> 
> regards,
> Ryan
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general