BDR Replication issue

1 vote

0 answers

590 views

                          I am trying to setup 2-node BDR replication and i am getting the following error while running bdr_init_copy.

> /usr/pgsql-9.4/bin/bdr_init_copy -d "host=10.10.145.111
> dbname=apimgtdb port=5432" -U postgres
> --local-dbname="host=10.10.145.110 dbname=apimgtdb port=5432" -n nodeawswest -D  /postgres/pgsql-9.4/data



    LOG:  database system was interrupted; last known up at 2015-06-05 14:49:09 PDT
    LOG:  entering standby mode
    LOG:  starting up replication identifier with ckpt at 9/F5000060
    LOG:  redo starts at 9/F5000060
    LOG:  consistent recovery state reached at 9/F5000128
    LOG:  database system is ready to accept read only connections
    LOG:  started streaming WAL from primary at 9/F6000000 on timeline 1
    LOG:  recovery stopping at restore point "bdr_6157013497737678047", time 2015-06-05 14:56:57.137408-07
    LOG:  recovery has paused
    HINT:  Execute pg_xlog_replay_resume() to continue.
    ERROR:  cannot execute DELETE in a read-only transaction
    STATEMENT:  DELETE FROM pg_catalog.pg_shseclabel WHERE provider = 'bdr';
    LOG:  received smart shutdown request
    FATAL:  terminating walreceiver process due to administrator command
    LOG:  shutting down
    LOG:  database system is shut down



                        

Asked by Ravi Tammineni (11 rep)

Jun 5, 2015, 10:26 PM
Last activity: Jun 6, 2015, 03:01 AM

BDR Replication issue

Related Questions