Stack Overflow
Stack Overflow

Questions tagged [pg-hba.conf]

53 questions
1
vote
1 answer

no pg_hba.conf, just will not work. I have located and tried changing it many times

I have no pg_hba.conf error with Heroku Postgres. I have searched all over especially on here and tried many of the users suggestions. I have tried changing the pg_hba.conf file to pretty much all the different settings that a lot of the users on…
James
  • 13
  • 5
1
vote
0 answers

Error "no pg_hba.conf entry for host" when deploying

I need help to deploy my project to Heroku. Every time that I attempt to deploy my project I get this error: Error: no pg_hba.conf entry for host "104.57.187.158", user "epcifomwotivdd", database "dummyDB12", SSL off npm ERR! code ELIFECYCLE npm…
Juan Mireles
  • 31
  • 1
  • 3
1
vote
1 answer

Password Error when logging into POSTGRES on my MAC

I am having an issue that has been bothering me for some time now. It is with postgres on my mac. I set a password for postgres and I can not remember it for some reason. I have looked up and attempted several different methods for trying to reset…
Omar_Jandali
  • 485
  • 2
  • 7
  • 18
1
vote
1 answer

How to configure PostgreSQL to accept all incoming connections except postgres / admin

My question is how to configure it so that non-admin (non-postgres) accounts can login from the internet but the admin (postgres) user is only allowed from localhost or a limited IP range. What entries in the pg_hba.conf that let me set this up? I…
drchuck
  • 4,415
  • 3
  • 27
  • 30
1
vote
2 answers

How does Postgres host based authentication work?

I am installing DSPACE which needs PostgresSQL. Please see this link: DSPACE INSTALL It says: Then tighten up security a bit by editing pg_hba.conf and adding this line: host dspace dspace 127.0.0.1 255.255.255.255 md5. I have read on the…
user2338823
  • 501
  • 1
  • 3
  • 16
1
vote
1 answer

I'm updating my pg_hba.conf, but the file gets reset to default everyday

I've made my django instance accessible on pg_hba.conf. But every morning when I go to get started, I have to re-apply the changes because the file has reset back to its original content. This is a CentOS7 Server running Apache with cpanel, the…
EricH
  • 37
  • 6
1
vote
1 answer

Postgresql remote access no pg_hba.conf entry for host

I'm trying to get remote access to postgresql, installed on a server with IP A.A.A.A. There are two servers which one them has IP A.A.A.A, where postgresql has been installed on; and the other one has IP B.B.B.B. I've edited…
gmm
  • 943
  • 1
  • 17
  • 30
1
vote
1 answer

can i simplify the use of postgres_fdw if the foreign db is in the same server

my server has several databases. I want to be able to read db1 from queries in db2. I know I can use postgres_fdw to do it but that has a couple of drawbacks. The main one is that I have to pass credentials around, worry over when I change passwords…
pm100
  • 48,078
  • 23
  • 82
  • 145
1
vote
1 answer

unable to edit pg_hba.conf file in Postgresql

I want to create a backup of the original pg_hba.conf file (may be as pg_hba.conf.bk) and then add an entry into the existing pg_hba.conf file. So far this is what i've been trying to do, but every time it says permission denied even if i go via…
Aman Singh
  • 1,111
  • 3
  • 17
  • 31
1
vote
1 answer

PostgreSQL 9.5 Using ident in pg_hba

I am working on a local network based on Windows, and I would like to use the account system of the network to allow users to connect to my DB. As I understand the proper way is to set the pg_hba method on "ident" as such : host all all …
GuiOm Clair
  • 139
  • 2
  • 22
0
votes
0 answers

port 25060 failed: FATAL: pg_hba.conf rejects connection for host and can't connect to Digital Ocean server

We did not have any issue but did not run the Digital ocean DB seeding for months and when the team tried to re-do it, we experienced the below error within the Pgadmin. We've been blocked for over 1 week now. Full error: connection to server at…
Uma Annamalai
  • 1
  • 1
0
votes
0 answers

Postgres Remote connection issues

Pretty well-documented topic, but I haven't found my solution yet hence here I go. I am failing to connect to my Postgres database resulting in the following two errors. (the errors also occur with normal PG client or any other way to access the…
Kjell van Straaten
  • 43
  • 6
0
votes
0 answers

postgreSQL pg_hba.conf - connection refused when using a LAN domain with node.js-postgres - allowed with pgAdmin 4

Attempts to connect using pgAdmin 4 are successful. Attempts to connect using NPM package PG are refused. ConnectErr connect EHOSTUNREACH fe80::xx:xxxx:xxxx:xxxx:5432 - Local (fe80::xxxx:xxx:xxxx:xxx%en5:54602) Both attempts use the same client…
WhatsYourFunction
  • 621
  • 1
  • 9
  • 25
0
votes
0 answers

Customize pg_hba.conf on Docker compose

Trying to set up a Django multicontainer application for local development purposes. I haven't found a way to customize pg_hba.conf and postgresql.conf directly from the compose file. I don't want to rely on external scripts or even external files…
João Victor
  • 65
  • 1
  • 1
  • 5
0
votes
0 answers

Dbeaver : connection is closed by foreign host

im working on vmware on ubuntu i want connect util in postgres... enter image description here im also change pg_hba.conf and postgres.conf im changed listen addresses ='*' and host all all 0.0.0.0/0 …
js s
  • 1
1
2
3 4