PostgreSQL and 2-node failover cluster solutions
От | Chris Miles |
---|---|
Тема | PostgreSQL and 2-node failover cluster solutions |
Дата | |
Msg-id | 20021004190528.E9444@psychofx.com обсуждение исходный текст |
Ответы |
Re: PostgreSQL and 2-node failover cluster solutions
|
Список | pgsql-admin |
Hi, we have 2 PostgreSQL servers running multiple instances and would like to automate failover between them. We store db data on NFS storage on dedicated Netapps. We can currently perform manual failover by dropping the instance on one server and starting in on the other (the init scripts handle bringing virtual IP up/down and the NFS volume is automounted as needed). My question to you: are there any simple, reliable and free cluster/fail-over (whatever you'd like to call it) solutions that you know of to automate the above? I'm prepared to give a bit on the simple and free if necessary, although reliability is pretty important. I have been looking at Kimberlite, but it doesn't look like it supports NFS shared storage, only locally attached. Otherwise it is almost perfect. Many other offerings floating around are either expensive commercial, or overly complex requiring kernel patching and complicated setups. Any suggestions appreciated. Especially if you've already solved this! Regards, Chris
В списке pgsql-admin по дате отправления: