Re: How to desconfigure BDR?

Поиск

Список

Период

Сортировка

От	Ruth Melendo
Тема	Re: How to desconfigure BDR?
Дата	24 марта 2015 г. 12:33:37
Msg-id	003901d06615$9a70bb50$cf5231f0$@teltronic.es обсуждение исходный текст
Ответ на	How to desconfigure BDR? ("Ruth Melendo" <rmelendo@teltronic.es>)
Список	pgsql-admin

Дерево обсуждения

Hi,

I don´t see it very stable by the moment to put into production env. I´m still testing but it´s not easy to recover when fails. I´ve tunned my database just to use sequences with BDR, I´ve modify the creation scripts to be executed in parts to avoid problem in creating extensions with creation tables dependent and I´m working in an script that reconfigures all env when corrupted from scratch. Basically delete all configuration and databases and reconfigure postgres and restore the database from a dump because It costs a lot of time to recover env in each failed test….

Speaking of which, if I want to drop my database and it says that there are still active slots, should I done something like this;

SELECT slot_name FROM pg_replication_slots;

And for all slots in result.. SELECT pg_drop_replication_slot(slot_name);

Is there a better way to do it? Is there a way to force dropping database if there is active slots? In this case I don’t care about changes because I just want to delete all and start again from scratch…

Thanks!

Ruth Patricia Melendo Ventura

Software Engineer

TELTRONIC, S.A.U.

T: +34 976 465656 Ext. 179

F: +34 976 465722

www.teltronic.es

Logo40

De: Greg Spiegelberg [mailto:gspiegelberg@gmail.com]
Enviado el: viernes, 20 de marzo de 2015 22:04
Para: Ruth Melendo
Asunto: Re: [ADMIN] How to desconfigure BDR?

Ruth,

Side conversation... how has your experience with BDR been? I am curious as my employer funded its development and we have plans to use it extensively however it hasn't made it out of our lab environment yet due to dependencies within our application code.

Thanks!

-Greg

On Thu, Mar 19, 2015 at 4:30 AM, Ruth Melendo <rmelendo@teltronic.es> wrote:

If I have muy database working with BDR and the BDR schema is created. How can I desconfigure it to stop replication?

I comment BDR entries in PostgreSQL.conf in both nodes but when starting, it continues detecting the replica system. What am I doing wrong? I want to stop replica and continue working with my database normally…

Thanks in advance

Ruth.