Re: [ADMIN] Issue with Configuring BDR 1.0.2 in Postgresql 9.4
От | Andrew Foster |
---|---|
Тема | Re: [ADMIN] Issue with Configuring BDR 1.0.2 in Postgresql 9.4 |
Дата | |
Msg-id | 40B1CD71-7717-498C-8ED8-8E58F1B12C2A@educationalmeasures.com обсуждение исходный текст |
Ответ на | Re: [ADMIN] Issue with Configuring BDR 1.0.2 in Postgresql 9.4 ("Keefer, Brad (ITS)" <Brad.Keefer@its.ny.gov>) |
Список | pgsql-admin |
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
Sr. Database Administrator
7100 E. Belleview Ave, Suite 350
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 onlylocal 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 trustlocal replication postgres md5host all postgres 10.108.52.1/24 md5host all postgres 10.108.55.92/32 md5host all postgres 10.108.55.93/32 md5host replication postgres 10.108.52.1/24 md5host replication postgres 10.108.55.92/32 md5host replication postgres 10.108.55.93/32 md5host replication postgres 127.0.0.1/24 md5[10:08:46 root@dch342ml3pgsql>Brad KeeferRed Hat Consultant – RHCSAOffice of Information Technology ServicesTax & Finance Building 8, Floor 7, Harriman CampusC: 919-210-7045 | brad.keefer@its.ny.govFrom: 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 350Greenwood Village, CO 80111
303-548-6516
afoster@educationalmeasures.comOn 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 isbdrdemo=# 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 suppliedDETAIL: 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 statementSQL 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 PERFORMSQL 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 PERFORMserver closed the connection unexpectedlyThis probably means the server terminated abnormallybefore 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 KeeferRed Hat Consultant – RHCSAOffice of Information Technology ServicesTax & Finance Building 8, Floor 7, Harriman Campus
В списке pgsql-admin по дате отправления:
Предыдущее
От: "Keefer, Brad (ITS)"Дата:
Сообщение: Re: [ADMIN] Issue with Configuring BDR 1.0.2 in Postgresql 9.4
Следующее
От: Nikolay SamokhvalovДата:
Сообщение: Re: [ADMIN] [PERFORM] Monitoring tool for Postgres Database