Questions tagged [pg-hba.conf]
53 questions
0
votes
0 answers
Python psycopg2, NO postgresql etc service running on mashine... Where is the postgress driver? where is pg_hba.conf? (FATAL: no pg_hba.conf entry)
I am using -in Linux- python 3 and psycopg2 to connect to some postres databases:
import psycopg2 as pg
connection = None
try:
connection = pg.connect(
user = "username",
password = "...",
host = "host_ip",
port =…
ntg
- 12,950
- 7
- 74
- 95
0
votes
0 answers
psql (PostgreSQL) 9.2.24 / linux - cannot find pg_hba.conf as I need to adjust it
Version: psql (PostgreSQL) 9.2.24 - I also downloaded Version 11.8.
to download v 9 I just ran:
sudo apt-get update
sudo apt-get install python-psycopg2
sudo apt-get install postgresql postgresql-contrib
to get v 11 - I followed this github…
0004
- 1,156
- 1
- 14
- 49
0
votes
1 answer
Change PostgreSQL pg_hba.conf IPv6 local connection setting from ::1/128 to my own Temporary IPv6 Address doe not work
My postgresql connection works if I stick to the following default set up:
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all…
Helene
- 953
- 3
- 12
- 22
0
votes
0 answers
Is the server running on host "localhost"?
I have an issue with postgresql. I saw some posts editing pg_hba.conf but it doesn't work.
Here the issue :
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused (0x0000274D/10061)
Is…
Trokken
- 37
- 4
0
votes
1 answer
PostgreSQL (pg_hba.conf / postgresql.conf) The connection to the server was lost. Attempting reset: Failed
I have a problem with Postgres that others seem to have found but the solutions that are given somehow do not work for me. I explain:
WHAT I USE
MacOS 10.15.6
Installed through Homebrew
PostgreSQL 12.2 on x86_64-apple-darwin, compiled by Apple LLVM…
JourneyDS
- 113
- 14
0
votes
0 answers
Postgres pg_hba.conf localhost confusion
I've run into a scenario where an application couldn't see the database. My pg_hba.conf file had the following:
local all all trust
host all all 127.0.0.1/32 …
Rich_F
- 1,830
- 3
- 24
- 45
0
votes
1 answer
Database connection pg_hba.conf
When i'm trying to my database in Azure from intelij i always getting this error:
PS Access in Azure is on
The specified database user/password combination is rejected: [28000] FATAL: no pg_hba.conf entry for host "37.140.21.90", user "xxx",…
Daniil Baev
- 69
- 1
- 8
0
votes
0 answers
postgres 10 Peer authentication failed
I'm trying to log in to a database with this command:
psql -U user my_db
This is the error that gets thrown:
psql: FATAL: Peer authentication failed for user "user"
I figured it had something to do with my pg_hba.conf. I tried several things but…
C.Acarbay
- 424
- 5
- 17
0
votes
0 answers
pg_hba do not work according to the settings
I am running postgresql 10 at ubuntu 18 host in Digital Ocean.
This is my pg_hba.conf file:
# Database administrative login by Unix domain socket
local all postgres peer
# TYPE DATABASE USER …
JT_T
- 176
- 1
- 1
- 11
0
votes
1 answer
Format and content of lines in pg_hba.conf file
I installed Postgres 9.3 yesterday on Ubuntu 18.04 (using the Ubuntu package index). I need to add lines to the pg_hba.conf file to allow pgAdmin access on port 5432.
For example, I need to add a line in this format:
hostssl database user …
RTC222
- 2,025
- 1
- 20
- 53
0
votes
1 answer
Trying to load csv file to my postgres table using ETL pentaho data integration. Note: I am not a super user
I installed the ETL pentaho data integration tool properly .
When I try to connect my db.It is giving this error message.
Error connecting to database [test_db] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying…
Monish N
- 330
- 1
- 6
- 15
0
votes
3 answers
Postgres remote connection - Windows server
I have the following lines in pg_hba.conf. Postgres is installed on a Windows server.
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 …
Alex
- 1
- 1
- 3
0
votes
1 answer
PostgreSQL security local (pg_hba.conf )
In PostgreSQL we can just change local md5 to trust in pg_hba.conf. then we can access all data in database using psql without need of password.So anyone can change this line who can access local machine.
So, Is there way to password protect our…
0
votes
1 answer
postgresql pg_hba - can more than one local line be used?
This is with postgresql 9.6.9.
This is part of my pg_hba.conf file:
local sameuser all password
host sameuser all 127.0.0.1/32 password
host sameuser all …
nsayer
- 16,925
- 3
- 33
- 51
0
votes
0 answers
Line "host all all 0.0.0.0/0 md5" deleted from the pg_hba.conf file at the same time every day
I have added this line "host all all 0.0.0.0/0 md5" to my pg_hba.conf file to allow connections to my database.
Problem is that this line gets deleted around 13:07GMT everyday resulting in this error
"no pg_hba.conf entry for host "127.0.0.1", user…
emay
- 1