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
> [email protected]
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
