Re: Postgresql 9.4 BDR configuration error

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