Stack Overflow
Stack Overflow

Questions tagged [pg-hba.conf]

53 questions
10
votes
3 answers

PostgreSQL 11 configurations doesn't allow pgAdmin4 to connect

I'm pretty new to PostgreSQL so the question may be simple. So. I have installed PostgreSQL 11 and pgAdmin 4 on Fedora 29. I can connect to the database via terminal or AzureDataStudio, but when I try to connect with pgAdmin, I get this…
amiry jd
  • 27,021
  • 30
  • 116
  • 215
5
votes
2 answers

Postgres find configuration files in linux

I've spent lots of time to find Postgres configuration files like pg_hba.conf or postgresql.conf in different distributions of linux and also postgres versions itself! and I was very confused...
S.Hossein Asadollahi
  • 1,450
  • 2
  • 17
  • 22
4
votes
3 answers

Azure Database for PostgreSQL server: no pg_hba.conf entry for host

In my Azure portal I created the resource "Azure Database for PostgreSQL server". I set up the firewall to enable two Virtual Networks (in order to allow the correct functioning of two applications) and the IP address of my local computer (in order…
El_Merendero
  • 603
  • 3
  • 14
  • 28
4
votes
2 answers

sql_error_code = 28000 FATAL logs in working API

Heroku is hosting my node.js API and the PostgreSQL addon is responsible for my DB. I recently upgraded my heroku db plan from hobby-dev to standard-0 and got some issues with SSL connection. After setting sslmode=require, my new DB was performing…
Andre Amaral
  • 41
  • 1
  • 4
4
votes
1 answer

Connection refused - Is the server running locally and accepting

So I've got an error when trying to connect to a Postgres instance on OSX. I get this error: Connection refused Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? I run this: ps -ax | grep…
Steven Matthews
  • 9,705
  • 45
  • 126
  • 232
3
votes
0 answers

How to correctly set SSL in pg_hba.conf of postgreSQL-11?

In Ubuntu 18.04.02 Server Edition with postgreSQL-11 I want to add the possibility of SSL communication between the postgreSQL server and a client. I turned the ssl on in postgresql.conf : sudo nano /etc/postgresql/11/main/postgresql.conf ssl =…
user2315094
  • 759
  • 3
  • 16
  • 29
3
votes
1 answer

How can I edit pg_hba.conf programmatically?

I'm looking for a way to edit pg_hba.conf programmatically, similar to how pg_conftool allows you to edit postgresql.conf: ~$ pg_conftool 11 main set timezone 'UTC' I tried using pg_conftool to edit pg_hba.conf. Unfortunately, it only allows key =…
Hristo
  • 45,559
  • 65
  • 163
  • 230
3
votes
2 answers

postgres uses a database password or a user password

I imported a postgres database in my local postgres server. I had to connect to the database (to allows django to retrive data) using the file called setup.local. There is required to specify: DB_HOST=localhost, DB_NAME, DB_USER, DB_PASSWORD.…
ndrini
  • 81
  • 8
3
votes
1 answer

Peer authentication failed for user "postgres"

I have been using postgreSQL, trying to dump plain backup file using command: psql -U postgres DATABASE < path to file.backup But getting peer authentication failure. Even tried changing pg_hba.conf from peer to md5, but didn't work.
Yogesh Singh
  • 35
  • 1
  • 6
3
votes
5 answers

Rails: fe_sendauth: no password supplied (PG::ConnectionBad) from Ruby, but ok in Rails

I'm having problems assessing a postgres database from straight ruby. I've created a Postgres database using Rails >rails new www --database=postgresql using Rails 4.2.5 and Postgres is 9.4 It produces the following config/database.yml…
gnoll110
  • 332
  • 1
  • 4
  • 11
2
votes
2 answers

Suddenly, Heroku credentials to a PostgreSQL server gives FATAL password for user error

Without changing anything in my settings, I can't connect to my PostgreSQL database hosted on Heroku. I can't access it in my application, and is given error OperationalError: (psycopg2.OperationalError) FATAL: password authentication failed for…
Fredrik Alvsaker
  • 23
  • 1
  • 4
2
votes
1 answer

FIPS policy blocks access to RDS-Postgres on AWS

I am facing an access problem when I connect to a postgres database instance on AWS/RDS. The connection is made using the library NPGSQL. Debbugging and logging, I found that the problem occurs during theauthentication. The configuration of PG_HBA…
Massimiliano Carosi
  • 284
  • 4
  • 20
2
votes
1 answer

running automated Postgres backups on Linux

I'm using the scripts from here: https://wiki.postgresql.org/wiki/Automated_Backup_on_Linux I have changed the owner of the files to "postgres" and I tried running the backup script while being logged in as "postgres" my pg_hba.conf contains the…
Arya
  • 8,473
  • 27
  • 105
  • 175
1
vote
0 answers

SQLSTATE[08006] [7] could not connect to server postgresql

i'm working on a project where i have to put a website on a server and i'm encountering this error : SQLSTATE[08006] [7] could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP…
AlexandreTELOUK
  • 19
  • 2
1
vote
2 answers

How to update local files on all the postgres nodes

I have a multi-node Postgres cluster running in High availability mode following the primary-standby architecture. postgres-0 5/5 Running 0 111s postgres-1 …
Vishrant
  • 15,456
  • 11
  • 71
  • 120
1
2 3 4