Re: pgpool: DETAIL: no pool_hba.conf entry for host

From: Feike Steenbergen <feikesteenbergen(at)gmail(dot)com>
To: mjoigny(at)neteven(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pgpool: DETAIL: no pool_hba.conf entry for host
Date: 2016-03-16 12:51:03
Message-ID: CAK_s-G20ZOnF6K4UHiVL+yaGbkpMFc7PQj3+Ma9VwGa5jxbTcA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> "pgpool: DETAIL: no pool_hba.conf entry for host "myhost", user "myuser",
database "mydatabase", SSL off"

It seems pgAdmin3 on your Windows is trying to connect without ssl ("SSL
off").
When creating a connection in pgAdmin3, I have a tab called 'SSL' in my
pgAdmin3, where I can specify the sslmode. Setting it to prefer should
probably do the trick.

http://www.postgresql.org/docs/current/static/libpq-ssl.html#LIBPQ-SSL-SSLMODE-STATEMENTS

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message drum.lucas@gmail.com 2016-03-16 22:47:30 pg_toast growth out - PostgreSQL 9.2
Previous Message Sivadas.M 2016-03-16 03:41:35 Migration from OracleDB to Postgres