Re: Postgresql 9.4 BDR configuration error

Francesco,

To subscribe to the regular lists, you need to follow the 'new system'
link on that page which will take you here:

https://lists.postgresql.org/manage/

You'll need a community account if you don't have one already, and you
can get one by going here:

https://www.postgresql.org/account/

Thanks!

Stephen

* Francesco Andrisani (francesco(dot)andrisani(at)acotel(dot)com) wrote:
> Hi Stephen,
> I tried to subscribe to pgsql-general, but on pg subscribe page
> https://www.postgresql.org/community/lists/subscribe/, I'm not able (on
> select field to find pgsql-general...only country specific mailing lists.
>
> Thanks
>
> On Thu, Dec 7, 2017 at 5:02 PM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
>
> > Greetings Francesco,
> >
> > I'd suggest sending this to pgsql-general instead of pgus-general,
> > you're more likely to get responses there.
> >
> > Thanks!
> >
> > Stephen
> >
> > * Francesco Andrisani (francesco(dot)andrisani(at)acotel(dot)com) wrote:
> > > Hello all,
> > > I tried to create an Master master Cluster using Postgres-9.4 BDR on two
> > > nodes.
> > >
> > > On the node1 the db is already exist and it is large (about 3Gb). When I
> > > try to add node2 (I clone DB from node1 with pg_dumpall), after
> > configuring
> > > all (first and second node) following official BDR guide (
> > > http://bdr-project.org/docs/stable/quickstart.html) on last step (
> > > http://bdr-project.org/docs/stable/quickstart-enabling.html) on node2,
> > it
> > > blocks on "SELECT bdr.bdr_node_join_wait_for_ready();" and node2 log
> > print
> > > this:
> > >
> > >
> > > < 2017-12-07 09:33:15.781 EST >LOG: starting background worker process
> > > "bdr db: zabbix"
> > > < 2017-12-07 09:33:15.793 EST >ERROR: previous init failed, manual
> > cleanup
> > > is required
> > > < 2017-12-07 09:33:15.793 EST >DETAIL: Found bdr.bdr_nodes entry for bdr
> > > (6496055908800323183,1,16386,) with state=i in remote bdr.bdr_nodes
> > > < 2017-12-07 09:33:15.793 EST >HINT: Remove all replication identifiers
> > > and slots corresponding to this node from the init target node then drop
> > > and recreate this database and try again
> > > < 2017-12-07 09:33:15.795 EST >LOG: worker process: bdr db: zabbix (PID
> > > 26818) exited with exit code 1
> > >
> > > I'm unable to continua confiiguration.
> > > On node1 if I execute this command :
> > > zabbix=# select * from bdr.bdr_nodes;
> > > node_sysid | node_timeline | node_dboid | node_status |
> > node_name
> > > | node_local_dsn
> > > | node_init_from_dsn | node_read_only | node_seq_id
> > > ---------------------+---------------+------------+---------
> > ----+-----------+-------------------------------------------
> > ------------------------------------+--------------------+--
> > --------------+-------------
> > > 6494544977234587558 | 1 | 16386 | r |
> > zabbix01
> > > | user=postgres password=xxxxxxxx host=10.200.x.xx port=5432
> > dbname=zabbix
> > > | | f |
> > > (1 row)"
> > >
> > > I'm able to see only node1...not node2.
> > > Can someone help me to know?
> > > Thanks all.
> > >
> > > --
> > > ____________________________________________________
> > > *Francesco Andrisani*
> > > mailto:francesco(dot)andrisani(at)acotel(dot)com
> > > *Acotel Spa*
> > > http://www.acotel.com
> > > Via della Valle dei Fontanili, 29
> > > 00168 Roma
> > > Tel +390661141200
> > > Fax +39066149936
> > > ____________________________________________________
> > >
> > > Le informazioni contenute nella comunicazione che precede possono essere
> > > riservate e sono, comunque, destinate esclusivamente alla persona o
> > > all’ente sopraindicati. La diffusione, distribuzione e/o copiatura non
> > > autorizzata del documento trasmesso da parte di qualsiasi soggetto è
> > > proibita. La sicurezza e la correttezza dei messaggi di posta elettronica
> > > non possono essere garantite. Se avete ricevuto questo messaggio per
> > > errore, Vi preghiamo di contattarci immediatamente. Grazie.
> > >
> > > This message is for the named person's use only. It may contain
> > > confidential, proprietary or legally privileged information. No
> > > confidentiality or privilege is waived or lost by any transmission. If
> > you
> > > receive this message in error, please immediately delete it and all
> > copies
> > > of it from your system, destroy any hard copies of it and notify the
> > > sender. You must not, directly or indirectly, use, disclose, distribute,
> > > print, or copy any part of this message if you are not the intended
> > > recipient. Thanks
> >
>
>
>
> --
> ____________________________________________________
> *Francesco Andrisani*
> mailto:francesco(dot)andrisani(at)acotel(dot)com
> *Acotel Spa*
> http://www.acotel.com
> Via della Valle dei Fontanili, 29
> 00168 Roma
> Tel +390661141200
> Fax +39066149936
> ____________________________________________________
>
> Le informazioni contenute nella comunicazione che precede possono essere
> riservate e sono, comunque, destinate esclusivamente alla persona o
> all’ente sopraindicati. La diffusione, distribuzione e/o copiatura non
> autorizzata del documento trasmesso da parte di qualsiasi soggetto è
> proibita. La sicurezza e la correttezza dei messaggi di posta elettronica
> non possono essere garantite. Se avete ricevuto questo messaggio per
> errore, Vi preghiamo di contattarci immediatamente. Grazie.
>
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any transmission. If you
> receive this message in error, please immediately delete it and all copies
> of it from your system, destroy any hard copies of it and notify the
> sender. You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. Thanks