pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
How to desconfigure BDR? 2+ messages / 1 participants [nested] [flat]
* How to desconfigure BDR? @ 2015-03-19 10:30 Ruth Melendo <rmelendo@teltronic.es> 2015-03-24 09:33 ` Re: How to desconfigure BDR? Ruth Melendo <rmelendo@teltronic.es> 0 siblings, 1 reply; 2+ messages in thread From: Ruth Melendo @ 2015-03-19 10:30 UTC (permalink / raw) To: pgsql-admin 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to desconfigure BDR? 2015-03-19 10:30 How to desconfigure BDR? Ruth Melendo <rmelendo@teltronic.es> @ 2015-03-24 09:33 ` Ruth Melendo <rmelendo@teltronic.es> 0 siblings, 0 replies; 2+ messages in thread From: Ruth Melendo @ 2015-03-24 09:33 UTC (permalink / raw) To: 'Greg Spiegelberg' <gspiegelberg@gmail.com>; +Cc: 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 <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:^ permalink raw reply [nested|flat] 2+ messages in threadimage003.jpg (image/jpeg, 1.6K) download
view image
end of thread, other threads:[~2015-03-24 09:33 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2015-03-19 10:30 How to desconfigure BDR? Ruth Melendo <rmelendo@teltronic.es> 2015-03-24 09:33 ` Ruth Melendo <rmelendo@teltronic.es>
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