Re: Postgresql BDR Replication Setup Issue

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(at)2ndquadrant(dot)com]
Sent: Monday, June 08, 2015 4:17 PM
To: Ravi Tammineni; tomas(dot)vondra(at)2ndquadrant(dot)com; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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.