Hi Ian, Thank you so much for your help. After changing the hot_standby = on to hot_standby = off, everything is working fine. We have copied all parameters from current production environment. Thanks ravi -----Original Message----- From: Ian Barwick [mailto:ian@xxxxxxxxxxxxxxx] Sent: Monday, June 08, 2015 4:17 PM To: Ravi Tammineni; tomas.vondra@xxxxxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx Subject: Re: Postgresql BDR Replication Setup Issue Hi On 15/06/09 2:31, Ravi Tammineni wrote: > We are setting up 2-node Postgresql BDR replication at our place and I > am getting the following error after bdr_init_copy command. (...) > > Could not update security label: ERROR: cannot execute DELETE in a > read-only transaction (...) > > ====== Data from Node2 log file > > < 2015-06-08 10:08:45.957 PDT >LOG: entering standby mode It looks like you're trying to run BDR on a streaming replication standby. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services ________________________________________________________________________ The preceding e-mail message (including any attachments) contains information that may be confidential, be protected by the attorney-client or other applicable privileges, or constitute non-public information. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If you are not an intended recipient of this message, please notify the sender by replying to this message and then delete it from your system. You are on notice that further use, dissemination, distribution, or reproduction of this message is strictly prohibited and may be unlawful. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
