LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 12-04-2013, 01:44 AM   #1
kirukan
Senior Member
 
Registered: Jun 2008
Location: Eelam
Distribution: Redhat, Solaris, Suse
Posts: 1,272

Rep: Reputation: 148Reputation: 148
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?
 
Old 12-05-2013, 11:27 PM   #2
kirukan
Senior Member
 
Registered: Jun 2008
Location: Eelam
Distribution: Redhat, Solaris, Suse
Posts: 1,272

Original Poster
Rep: Reputation: 148Reputation: 148
Anybody configured postgresql as "Synchronous Multimaster Replication"?
 
Old 12-12-2013, 10:30 AM   #3
kirukan
Senior Member
 
Registered: Jun 2008
Location: Eelam
Distribution: Redhat, Solaris, Suse
Posts: 1,272

Original Poster
Rep: Reputation: 148Reputation: 148
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] configure freeradius with WPA2 enterprise tyrant9999 Linux - Server 2 11-19-2010 09:53 AM
help how to install and configure FreeRadius on Fedora core 4 angst_nu Linux - Networking 0 03-01-2006 01:46 AM
How to configure freeradius on Fedora Core 2? bobier Fedora 0 10-18-2004 09:40 PM
how to configure wpa support on freeradius? ericmeng Linux - Security 1 06-19-2004 01:41 PM
configure md5 with FreeRADIUS abdullahgee Programming 3 04-08-2004 10:05 AM


All times are GMT -5. The time now is 04:41 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration