From: Ruth Melendo <rmelendo@teltronic.es>
To: 'Greg Spiegelberg' <gspiegelberg@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to desconfigure BDR?
Date: Tue, 24 Mar 2015 10:33:36 +0100
Message-ID: <003901d06615$9a70bb50$cf5231f0$@teltronic.es> (raw)
In-Reply-To: <CAEtnbpVMZ7=Yf57=qXtYGYe8GgaAB6hOinAo-v3J=74CP-Bg9A@mail.gmail.com>
References: <000601d0622f$c36f4a60$4a4ddf20$@teltronic.es>
<CAEtnbpVMZ7=Yf57=qXtYGYe8GgaAB6hOinAo-v3J=74CP-Bg9A@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
<http://www.teltronic.es/; 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.
Attachments:image003.jpg (image/jpeg, 1.6K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rmelendo@teltronic.es, gspiegelberg@gmail.com
Subject: Re: How to desconfigure BDR?
In-Reply-To: <003901d06615$9a70bb50$cf5231f0$@teltronic.es>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox