Freeradius configure with postgresql
 

Hi,
I plan to use postgres for freeradius authentication and accounting.
Two Radius servers (radius1 and radius2)
Two Postgres servers (db1 and db2)
For radius1, db1 is the primary and db2 is the secondary
For radius2, db2 is the primary and db1 is the secondary
And then need to configure the posgresql replication.


http://www.postgresql.org/docs/9.2/s...solutions.html

As per plan, I am thinking to use master-master replication but when we use "Synchronous Multimaster Replication" there will be performance impact if there is heavy write.

I believe there will be heavy write in accounting table. So, in this situation.

Which replication method is more suitable for master-master setup?

Anybody configured postgresql as "Synchronous Multimaster Replication"?

Is postgresql do fully auto failover in Master-Slave WAL-Streaming replication? I come to know postgresql doens't have such native option for auto failover to promote slave node as master, Alternatively we use some third-party add-on's (middleware) like pgpool, pgbouncer, postgres-XC etc do auto failover. Any idea which add-on is stable and easy to setup