-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

1.  Anyone have a query I can run that will tell me wether the DB I've 
connected to is active or passive?
2.  When trying to failover...
I pass the following to slonik:
cluster name = tsyslog_cluster;
lock set (id = 1, origin = 1);
wait for event (origin = 1, confirmed = 2);
move set (id = 1, old origin = 1, new origin = 2);
wait for event (origin = 1, confirmed = 2);

I get:  <stdin>:2: ERROR: syntax error at or near lock

any ideas?

3.  how do I query Postgresql/Slony to find out how far behind it is?

- -- 

- --------------------------------------------------
Jeremy M. Guthrie        jeremy.guthrie at berbee.com
Senior Network Engineer        Phone: 608-298-1061
Berbee                           Fax: 608-288-3007
5520 Research Park Drive         NOC: 608-298-1102
Madison, WI 53711
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFA9IEsqtjaBHGZBeURAoWTAJ9f8FRaNEVUbXSQi9YCuzHsYnm+cACfWkrp
EIUpos73/P/1j3aSq9lo2po=
=/B4P
-----END PGP SIGNATURE-----