Thread: [ADMIN] Issue with Configuring BDR 1.0.2 in Postgresql 9.4

On Jun 2, 2017, at 8:00 AM, Keefer, Brad (ITS) <Brad.Keefer@its.ny.gov> wrote:

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.keefer@its.ny.gov

www.its.ny.gov

On Jun 2, 2017, at 8:09 AM, Keefer, Brad (ITS) <Brad.Keefer@its.ny.gov> wrote:

This is what I have:

 

# TYPE  DATABASE        USER            ADDRESS                 METHOD

 

# "local" is for Unix domain socket connections only

local   all             all                                     trust

# IPv4 local connections:

host    all             all             127.0.0.1/32            trust

# IPv6 local connections:

host    all             all             ::1/128                 trust

# Allow replication connections from localhost, by a user with the

# replication privilege.

#local   replication     postgres                                trust

#host    replication     postgres        127.0.0.1/32            trust

#host    replication     postgres        ::1/128                 trust

local    replication     postgres                              md5

host    all     postgres        10.108.52.1/24           md5

host    all     postgres        10.108.55.92/32           md5

host    all     postgres        10.108.55.93/32           md5

host    replication   postgres 10.108.52.1/24    md5

host    replication     postgres        10.108.55.92/32           md5

host    replication     postgres        10.108.55.93/32           md5

host    replication     postgres        127.0.0.1/24                md5

[10:08:46 root@dch342ml3pgsql>

 

 

 

Brad Keefer

Red Hat Consultant – RHCSA

 

Office of Information Technology Services

Tax & Finance Building 8, Floor 7, Harriman Campus

C: 919-210-7045 | brad.keefer@its.ny.gov

www.its.ny.gov

 

From: Andrew Foster [mailto:afoster@educationalmeasures.com] 
Sent: Friday, June 02, 2017 10:07 AM
To: Keefer, Brad (ITS) <Brad.Keefer@its.ny.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Issue with Configuring BDR 1.0.2 in Postgresql 9.4

 

ATTENTION: This email came from an external source. Do not open attachments or click on links from unknown senders or unexpected emails.

Morning Brad, 

 

Could you pass along your pg_hba.conf for 10.108.55.92? Your issue may be there.

 

 

Regards,

 

Andrew Foster | Educational Measures, LLC
Sr. Database Administrator
7100 E. Belleview Ave, Suite 350

Greenwood Village, CO 80111
303-548-6516
afoster@educationalmeasures.com

 

On Jun 2, 2017, at 8:00 AM, Keefer, Brad (ITS) <Brad.Keefer@its.ny.gov> wrote:

 

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.keefer@its.ny.gov

www.its.ny.gov