Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YaLDP-0006xY-4V for pgsql-admin@arkaria.postgresql.org; Tue, 24 Mar 2015 09:33:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YaLDN-00029j-GK for pgsql-admin@arkaria.postgresql.org; Tue, 24 Mar 2015 09:33:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YaLDM-00029d-HQ for pgsql-admin@postgresql.org; Tue, 24 Mar 2015 09:33:36 +0000 Received: from correo.teltronic.es ([93.92.233.233] helo=teltronic.es) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YaLDC-0000Og-S0 for pgsql-admin@postgresql.org; Tue, 24 Mar 2015 09:33:35 +0000 Received: from RMELENDOW7 (unknown [192.168.8.40]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by correo.teltronic.es (Postfix) with ESMTP id D83A8357A4A; Tue, 24 Mar 2015 10:33:23 +0100 (CET) From: "Ruth Melendo" To: "'Greg Spiegelberg'" Cc: References: <000601d0622f$c36f4a60$4a4ddf20$@teltronic.es> In-Reply-To: Subject: Re: How to desconfigure BDR? Date: Tue, 24 Mar 2015 10:33:36 +0100 Message-ID: <003901d06615$9a70bb50$cf5231f0$@teltronic.es> MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_003A_01D0661D.FC36A9F0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQIZl+TFS7CrbTz82Xhm84gF9gjm7gDr1A2znJGaDRA= Content-Language: es X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_003A_01D0661D.FC36A9F0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_003B_01D0661D.FC36A9F0" ------=_NextPart_001_003B_01D0661D.FC36A9F0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, =20 I don=C2=B4t see it very stable by the moment to put into production = env. I=C2=B4m still testing but it=C2=B4s not easy to recover when = fails. I=C2=B4ve tunned my database just to use sequences with BDR, = I=C2=B4ve modify the creation scripts to be executed in parts to avoid = problem in creating extensions with creation tables dependent and = I=C2=B4m 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=E2=80=A6.=20 =20 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; =20 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=E2=80=99t care = about changes because I just want to delete all and start again from = scratch=E2=80=A6=20 =20 Thanks! =20 Ruth Patricia Melendo Ventura Software Engineer TELTRONIC, S.A.U. T: +34 976 465656 Ext. 179 F: +34 976 465722=20 www.teltronic.es Logo40 =20 De: Greg Spiegelberg [mailto:gspiegelberg@gmail.com]=20 Enviado el: viernes, 20 de marzo de 2015 22:04 Para: Ruth Melendo Asunto: Re: [ADMIN] How to desconfigure BDR? =20 Ruth, =20 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. =20 Thanks! -Greg =20 On Thu, Mar 19, 2015 at 4:30 AM, Ruth Melendo = wrote: If I have muy database working with BDR and the BDR schema is created. = How can I desconfigure it to stop replication?=20 =20 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=E2=80=A6 =20 Thanks in advance =20 Ruth. =20 =20 ------=_NextPart_001_003B_01D0661D.FC36A9F0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi,

 

I don=C2=B4t see it very stable by the moment to put into production = env. I=C2=B4m still testing but it=C2=B4s not easy to recover when = fails. I=C2=B4ve tunned my database just to use sequences with BDR, = I=C2=B4ve modify the creation scripts to be executed in parts to avoid = problem in creating extensions with creation tables dependent and = I=C2=B4m 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=E2=80=A6. =

 

Speaking of which,=C2=A0 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=E2=80=99t care = about changes because I just want to delete all and start again from = scratch=E2=80=A6

 

Thanks!

 

Ruth Patricia = Melendo Ventura

Software Engineer

TELTRONIC, S.A.U.=

T: +34 976 465656=C2=A0=C2=A0 Ext. 179

F: +34 976 465722

www.teltronic.es

=

3DLogo40

 

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=E2=80=A6

 

Thanks in advance

 

Ruth.

 

 

------=_NextPart_001_003B_01D0661D.FC36A9F0-- ------=_NextPart_000_003A_01D0661D.FC36A9F0 Content-Type: image/jpeg; name="image003.jpg" Content-Transfer-Encoding: base64 Content-ID: /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwkHBgoJCAkLCwoMDxkQDw4ODx4WFxIZJCAmJSMg IyIoLTkwKCo2KyIjMkQyNjs9QEBAJjBGS0U+Sjk/QD3/2wBDAQsLCw8NDx0QEB09KSMpPT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT3/wAARCAA0AD8DASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2as3W NdstEg8y6k+cj5I15Zvw/rVXxJ4hXRoVjgCy3knCR+g9T/h3qhonhYmb+0tcYzXbHcEc5VPr7+3Q VvCklHnqbfmc06zc/Z0tX1fRFC5vta121kvJLn+x9IUZ3Z/eOPboTnt0/GtTwHMW8LhpCwjWWTY8 jcsuc5Pp3/KsTV7mbxl4gTSLNtunwNukde+OC39B+dXfF+pCzt4tFsAFUoA4Uchf4VH1rqlBzSpJ Wb19F5+ZyKoqblWbulp6vy8iDxD41mkla00clcNtMwGS/so/rWSvh3xIxfUt7pNbjzA0kx3nvgf1 H4V1vhXwzHpUC3Vyub2ReQekY9B7+tXvE+oDTPD15OSA3llE92PA/nS9tGElTor59yvYSqRdWu/O 3Yd4c1Vta0K1vXXbJIuHA6bgcHH5VqVyXhWefR/DtjFc27eS671cdRuOf611MM8dwgeJwyn0rzZV qUqsqcXqm9D0acZ+yjKXVI8+tNVtIvEdzqGrJK0iufLRVDbSDjnnsBiruu+OYLnTZbbT45lklXaZ HAG0d+/pWxe+DdOvruS4Zp42kO5ljYAZ79q4zXdKtbDxFFp8Bk8rMYdpG5O488/Q168HRrST1ul8 tDxpRxGHi1pZvfq7kGg+IrnRQ1vp9nDLPcMBufJY+gABrd8MWj6z4hl1C6wfKbzG9N56Y+n+Fdja 6TYWQ/0W0hiONu5EAbH161yGl6onhK7vrS+gmO5wyFAOQM4644qfaqqp+zj7xU6Loyp+1l7qb9F2 O6JCqSxwBySa871S9PjXxNa6fa7jYQtlmxjcP4m/LgVHquv6l4omFjYQOkJP+rQ5LD1Y+ldh4b8O xaBaMu4SXEpBkkxj8B7CsVBYZc0vi6LsdLqfWpcsPhW77+RqG3iNuINi+UFChewHasCCZtOvZFU5 VSVI9fStW/1SO1BSMiSY8BR2+tVtM01y/wBouRyckKe+e5r5vG3r14Ro/Et329f8j2aPuQbnszYr Km8P6fPrH9ozx+ZcALgM3yjHQ4rVrHEM7XbRkhnJLueoP93P9BXsxk47M45QjL4lc0HuJFkZVh8w jsrjOPXBrNv4rfVlxc6Z54jO3cZUBU+mQamitbhrdd8eJCcPl+XH1HbPPqaFsZXtJEeJNwclFzgH t+HHSs7STvGTX3f5FNRkrSVyK2hk06FY7DT7a1Rmx88nLH8M5/OrBsr24yLm8Cof4YVxn8TQbOZp kRo4xDGVZCG+7jtitGs5Ued3nJv5/wCVioy5VaKSKtrpttaHMUfzf3m5NWqKKuEIwXLFWQnJyd2F NCKpYgAFjkn1ooqxDqKKKACiiigAooooA//Z ------=_NextPart_000_003A_01D0661D.FC36A9F0--