Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [pg-hba.conf]

45 questions
330
votes
12 answers

connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host

I am trying to run a website sent to me but after doing so this error appeared connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "4X.XXX.XX.XXX", user "userXXX", database "dbXXX", SSL off in C:\xampp\htdocs\xmastool\index.php on…
Jin
  • 3,413
  • 3
  • 12
  • 6
27
votes
6 answers

How to restart PostgreSQL server under CentOS 7

I installed PostgreSQL 10.1 under a CentOS 7.3 environment. The service is started (postmaster.pid file present under /var/lib/pgsql/10/data), but I need to reload configuration or restart the server following a change in pg_hba.conf. However,…
Sébastien Clément
  • 1,713
  • 3
  • 17
  • 27
18
votes
2 answers

psql: FATAL: Peer authentication failed for user

I just installed PostgreSQL 9.4 on Ubuntu 15.10. I created a user with createuser -P myuser I created a database with createdb -O myuser mydatabase I edited pg_hba.conf and added local mydatabase myuser md5 I restarted PostgreSQL with sudo service…
Daniel
  • 297
  • 1
  • 2
  • 7
16
votes
1 answer

How do I query the running pg_hba configuration?

I want to test if a replication connection is authorized by pg_hba.conf on the provider before issuing the replication-starting command, and don't know how. (I have access to both unix and postgresql shells on both nodes) For the non-replication…
victorjtfranco
  • 163
  • 1
  • 1
  • 5
11
votes
1 answer

Postgres seems to ignore listen_addresses setting

I'm trying to DISABLE remote client access on my Postgres 9.5.7 database (running Ubuntu 16.04). I made what I thought are the correct changes (see below) to no avail. I can think of two reasons why my changes wouldn't work: I'm editing the wrong…
stvsmth
  • 213
  • 1
  • 2
  • 8
10
votes
3 answers

Unexpected PostgreSQL restart

My PostgreSQL server unexpectedly restarted with such messages: 2017-08-16 03:44:34 GMT LOG: received fast shutdown request 2017-08-16 03:44:34 GMT LOG: aborting any active transactions 2017-08-16 03:44:34 GMT FATAL: terminating connection due to…
Pavel Naydenov
  • 103
  • 1
  • 1
  • 4
8
votes
2 answers

How to check the syntax of pg_hba.conf and other postgresql conf files on ubuntu/debian/linux?

Many times, the postgresql service can't restart after some configuration changes. Is there any command line tool allowing to check the syntax of pg_hba.conf and other pg *.conf files before reloading/restarting the service, or even better, after…
Rémi B.
  • 331
  • 1
  • 3
  • 8
7
votes
2 answers

What am I doing wrong with pg_hba.conf?

I'm trying to make it so that local connections to the database don't require a login. So I added the line local all all trust to the pg_hba.conf file, but then when I load pgAdmin and try to connect to the server it just says FATAL: could…
temporary_user_name
  • 193
  • 1
  • 2
  • 7
4
votes
1 answer

postgresql - a local replication entry doesn't work

Maybe it's just too early in the morning, but I can't seem to get pg_basebackup working for a local user. This is part of testing for an hourly backup automated script. I added a line to pg_hba.conf for this and it looks like: local replication …
user2288360
  • 41
  • 1
  • 2
4
votes
2 answers

Postgresql pg_hba.conf changes are ignored or not loaded

Using Postgresql 9.3 on Ubuntu 14.04.4 LTS I've been changing the /etc/postgresql/9.3/main/pg_hba.conf config file madly trying to make a change that will allow me to log in with any user remotely. My current configuration looks like so: host all…
subdavis
  • 181
  • 1
  • 7
4
votes
2 answers

Using postgres database from another computer

I have PostgreSQL version 9.5 installed at my machine (Windows 7 Enterprise x64 bit version). I have several databases in schema 'public'. I would like to use/access one of these databases from another machine (Windows 7) using LAN connectivity (so…
Jibran Khan
  • 41
  • 1
  • 1
  • 2
4
votes
1 answer

I Need Help Setting Up Roles and Passwords in PostgreSQL

I'm using the postgres.app on my Mac Mini Server running version 9.4.0 using El Capitan. I have not done any customization in pg-hba.conf. I do not have a .pgpass file. I believe that .pgpass is used to store passwords where you would not have to…
Pamela Cook - LightBe Corp
  • 155
  • 1
  • 1
  • 7
3
votes
1 answer

Error: FATAL: no pg_hba.conf entry for host - PostgreSQL - pg_hba.conf is empty

I upgraded the PostgreSQL database from version 10 to 11. As I tried to access the database from a client pgadmin4 console, I got the below error: I checked the two file postgresql.conf and pg_hba.conf in the system. However, when I tried to open…
RBK
  • 133
  • 1
  • 5
3
votes
1 answer

Why does the PG manual state to modify the "pg_hba.conf" file before starting the server the first time?

The following is from https://www.postgresql.org/docs/current/static/creating-cluster.html with original emphasis on before: or modify the generated pg_hba.conf file after running initdb, but before you start the server for the first time. Is the…
da99
  • 339
  • 4
  • 11
3
votes
1 answer

How do I enable md5 authentication for only one user?

I just installed Postgres 9.2 on CentOS 7. I want to keep peer authentication for all my users except one, which I would like to be able to access via "psql" through any user's account. I tried editing my /var/lib/pgsql/data/pg_hba.conf to be…
Dave
  • 565
  • 7
  • 17
  • 34
1
2 3