Search Postgresql Archives

Postgres HA

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

 

I am a DBA at the University of South Australia. For PostgreSQL High Availability, we currently have setup a Master/Slave across two datacenters using PostgreSQL (WAL) streaming replication. We use an LTM (load balancer) server that sits between the application servers and the PostgreSQL server that directs connections to the Master (and the Slave if failover occurs). We also have watchdog processes on the PostgreSQL servers that polls the LTM to determine who is Master and perform automatic failover if required. I am looking at options to improve our high availability.

I would like to know how other organizations in different industries (other than education) setup High Availability on their PostgreSQL environments.

What  tools do you use. Are they commercial licensed products? How is the architecture setup and how do you do recovery of new slave.

Your information is greatly appreciated.

 

Regards

Dylan

 

Dylan Luong

Information Strategy & Technology Services

University of South Australia

A Building, Room E2-07, Mawson Lakes Campus

MAWSON LAKES

South Australia  5095

 

Email:        dylan.luong@xxxxxxxxxxxx

Phone:    +61 8 83023629

Fax:         +61 8 83023577

WWW:    http://www.unisa.edu.au

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux