Re: bdr replication

Поиск
Список
Период
Сортировка
От Slava Bendersky
Тема Re: bdr replication
Дата
Msg-id 528858661.2080006.1459393759836.JavaMail.zimbra@skillsearch.ca
обсуждение исходный текст
Ответ на bdr replication  (Slava Bendersky <volga629@skillsearch.ca>)
Ответы Re: bdr replication  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Hello Craig,
Is any share storage technology recommended for PostgreSQL in  virtual environment ?
Ok what I will do is going take backups, shutdown both virtual servers and place all vm use local disk on server only.
volga629


From: "Craig Ringer" <craig@2ndquadrant.com>
To: "volga629" <volga629@skillsearch.ca>
Cc: "pgsql-general" <pgsql-general@postgresql.org>
Sent: Wednesday, 30 March, 2016 23:57:28
Subject: Re: [GENERAL] bdr replication

On 31 March 2016 at 10:43, Slava Bendersky <volga629@skillsearch.ca> wrote:
Hello Craig,
The current setup is two server which run libvirt and for storage which run glusterfs (storage server feed two virtual servers).  Right now is no fencing in place. Each of the nodes have one  PostgreSQL vm with bdr.

That's a disaster waiting to happen. You can't just share storage like that in PostgreSQL, BDR or otherwise. I'm amazed it didn't fail earlier.

Try to dump whatever data you can recover, initdb a new normal PostgreSQL instance, restore, and set up normal replication. Look into repmgr, pgbarman, etc. Read the manual on replication, backup and failover. Do _not_ use shared storage.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-general по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: bdr replication
Следующее
От: John R Pierce
Дата:
Сообщение: Re: bdr replication