Re: Issue with Configuring BDR 1.0.2 in Postgresql 9.4

Have you set up a .pgpass file on the server you’re connecting from?

Andrew Foster | Educational Measures, LLC
Sr. Database Administrator
7100 E. Belleview Ave, Suite 350
Greenwood Village, CO 80111
303-548-6516
afoster(at)educationalmeasures(dot)com

> On Jun 2, 2017, at 8:09 AM, Keefer, Brad (ITS) <Brad(dot)Keefer(at)its(dot)ny(dot)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(at)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(dot)keefer(at)its(dot)ny(dot)gov <mailto:brad(dot)keefer(at)its(dot)ny(dot)gov>
> www.its.ny.gov <http://www.its.ny.gov/>
>
> From: Andrew Foster [mailto:afoster(at)educationalmeasures(dot)com <mailto:afoster(at)educationalmeasures(dot)com>]
> Sent: Friday, June 02, 2017 10:07 AM
> To: Keefer, Brad (ITS) <Brad(dot)Keefer(at)its(dot)ny(dot)gov <mailto:Brad(dot)Keefer(at)its(dot)ny(dot)gov>>
> Cc: pgsql-admin(at)postgresql(dot)org <mailto:pgsql-admin(at)postgresql(dot)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(at)educationalmeasures(dot)com <mailto:afoster(at)educationalmeasures(dot)com>
>
> On Jun 2, 2017, at 8:00 AM, Keefer, Brad (ITS) <Brad(dot)Keefer(at)its(dot)ny(dot)gov <mailto:Brad(dot)Keefer(at)its(dot)ny(dot)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(dot)keefer(at)its(dot)ny(dot)gov <mailto:brad(dot)keefer(at)its(dot)ny(dot)gov>
> www.its.ny.gov <http://www.its.ny.gov/>