Issue with Configuring BDR 1.0.2 in Postgresql 9.4

From: "Keefer, Brad (ITS)" <Brad(dot)Keefer(at)its(dot)ny(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Issue with Configuring BDR 1.0.2 in Postgresql 9.4
Date: 2017-06-02 14:00:05
Message-ID: SN1PR09MB0783C1CAD493413D66A4B68DDCF70@SN1PR09MB0783.namprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

So, I'm trying to set up a simple two-node Postgres Replication cluster, and things are going ok until I try and set up the DSN. The command I am using is

bdrdemo=# SELECT bdr.bdr_group_create(local_node_name := 'node1', node_external_dsn := 'host=10.108.55.92 port=5432 dbname=bdrdemo');

but when I run that, I receive the following error:

FATAL: could not connect to the server in non-replication mode: fe_sendauth: no password supplied

DETAIL: dsn was: connect_timeout=30 keepalives=1 keepalives_idle=20 keepalives_interval=20 keepalives_count=5 host=10.108.55.92 port=5432 dbname=bdrdemo fallback_application_name='bdr (6427018047201618294,1,16384,):bdrnodeinfo'
CONTEXT: SQL statement "SELECT * FROM bdr_get_remote_nodeinfo(node_local_dsn)"
PL/pgSQL function internal_begin_join(text,text,text,text) line 42 at SQL statement
SQL statement "SELECT bdr.internal_begin_join(
'bdr_group_join',
local_node_name,
CASE WHEN node_local_dsn IS NULL THEN node_external_dsn ELSE node_local_dsn END,
join_using_dsn)"
PL/pgSQL function bdr_group_join(text,text,text,text,integer,text[]) line 21 at PERFORM
SQL statement "SELECT bdr.bdr_group_join(
local_node_name := local_node_name,
node_external_dsn := node_external_dsn,
join_using_dsn := null,
node_local_dsn := node_local_dsn,
apply_delay := apply_delay,
replication_sets := replication_sets)"
PL/pgSQL function bdr_group_create(text,text,text,integer,text[]) line 84 at PERFORM
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

I'm running this on a RHEL 7.3 OS with SELinux set to Permissive.

I also enabled the bdr extension via the shared_preload_libraries lin in the postgresql.conf file, and created the extension btree_gist in the bdrdemo database prior to running the SELECT statement above.

Not sure what I am missing, but any pointers/advice you could give would be greatly appreciated.

Thanks.

Brad Keefer
Red Hat Consultant - RHCSA

Office of Information Technology Services
Tax & Finance Building 8, Floor 7, Harriman Campus
C: 919-210-7045 | brad(dot)keefer(at)its(dot)ny(dot)gov<mailto:brad(dot)keefer(at)its(dot)ny(dot)gov>
www.its.ny.gov

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Foster 2017-06-02 14:07:16 Re: Issue with Configuring BDR 1.0.2 in Postgresql 9.4
Previous Message Mahesh Jhala 2017-06-01 19:46:51 Re: Can manual vacuuming conflict with auto vacuuming?