Bill Moran wrote:
> Each of our DB servers has multiple IP addresses and firewall policies
> dictate who can talk to who.  For example, two DB servers in the same
> data center will talk directly to each other on their DB IPs, whereas
> a DB server in another facility will have to go through two firewalls
> and connect to another DB's management IP.  In somewhat less abstract
> terms, if I have 3 servers:
> db0 - datacenter 1
> db1 - datacenter 1
> db2 - datacenter 2
> 
> If I execute slonik commands from db1, it will use the hostname
> db0-db to connect to db0, but db2 will use the hostname db0-mgmnt.

Clever.  Thanks for the info, this helped my understanding a lot.  Out
of curiosity, couldn't you also tunnel the inter-datacenter db traffic
and add some routes down the tunnel to simplify slony config paths?

> Are you running Linux by any chance?  

Only on my personal workstations.  Our postgresql servers are FreeBSD.
If I get motivated this weekend, I'll setup some linux virtual machines
to test on.

Dane