Re: Postgresql HA questions
| От | Steve Pritchard |
|---|---|
| Тема | Re: Postgresql HA questions |
| Дата | |
| Msg-id | CAF7Aqmwb8Oo3rDwjwHEENF6o8Be3oUi31hn5G8qZBwYMH+am2g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Postgresql HA questions (Israel Brewster <israel@ravnalaska.net>) |
| Ответы |
Re: Postgresql HA questions
|
| Список | pgsql-general |
Israel,
I can't answer all your questions, but we've just set up a HA pair with Hot Standby using Corosync/Pacemaker. However we haven't deployed this 'live' yet.
We originally found a presentation from The PostgreSQL Conference PostgreSQL High Availability with Corosync/Pacemaker, and then bought the book PostgreSQL 9.0 High Performance (a sample chapter is available as a PDF).
All working out well in testing at the moment.
Steve Pritchard
British Trust for Ornithology
On 23 September 2015 at 17:36, Israel Brewster <israel@ravnalaska.net> wrote:
<snip>With my application servers, I have a system set up using corosync and pacemaker that allows for seamless fail-over between the two machines, with the IP address and all services moving smoothly between the two at will. Ideally, I would have a similar setup with my database servers, so the applications never even know that there was a switch. Is this possible with Postgresql at all? Does it make a difference that at least one app has an "always on" connection to the DB Server?<snip>
В списке pgsql-general по дате отправления: