Questions tagged [pg-hba.conf]

The tag has no usage guidance.

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
1 answer
1k views

pg_hba error while setting up repmgr

Please help me to figure it out, help is much appreciated! ERROR: FATAL: no pg_hba.conf entry for replication connection from host "172.18.0.4", user "repmgr", SSL on The following is a list of my ...
CJ Chang's user avatar
  • 285
1 vote
0 answers
29 views

Allow databases start with specific name

In PostgreSQL sometimes we replace a database, we rename the old when a create a new one, example: Database: test Rename database to: test-04-04 (date) Create a newdatabase: test Now we have a lot ...
BOUKANDOURA Mhamed's user avatar
0 votes
0 answers
30 views

FATAL: could not load pg_hba.conf error when including a @user file

I've got a working pg_hba.conf file in the default location that lists specific users and address (Windows PG14). The documentation states that I can also list users and address by creating a file ...
Ronald King's user avatar
0 votes
0 answers
753 views

pg_cron connection refused with postgres login

I am trying to run a function periodically with pg_cron but every time it wants to execute it throws connection refused. the cron job is created using the postgres user. pg_hba.conf local all ...
user avatar
0 votes
1 answer
5k views

pg_hba.conf and postgresql.conf in old installation directory

I have installed the PostgreSQL 9.4 on my MacBook via MacPorts, and I am trying to edit pg_hba.conf, but I don't see it in my current installation. Furthermore, psql is reporting that config_file is ...
Imran's user avatar
  • 1