I've read so many SOF posts related to this problem and experimented with the pg_hba.conf file to try make a connection with no success. I don't understand why I get this message since I thought this was solved when I assigned a password for the postgres role. I get the following error message:įATAL: Ident authentication failed for user "postgres" sudo netstat -nlt | grep 5432Īs an alternative, I establish an ssh tunnel with ssh -N -L localhost:5432:localhost:5432 and doing this in pgAdmin and hitting save. So I go and double check that the port is listening. Is the server running on host "XX.XXX.XX.XX" and accepting I get the following error message:Ĭould not connect to server: Connection timed out (0x0000274C/10060) I fire up pgAdmin 4 on my local machine and do the following and hit save. Psql -h 127.0.0.1 -U postgres # this works now This fine gentlemen says that the VM username postgres loggin password and the database role postgres password are two different things ( Link), so I do the following to alter postgres role's password # bashĪLTER USER postgres PASSWORD 'new_password' Psql: FATAL: Ident authentication failed for user "postgres"
So I loggin with my personal account and do this psql -h 127.0.0.1 -U postgres, which gives me this: Nano /var/lib/pgsql/11/data/nfīefore I move on, I just wanted to see if I could loggin to psql as postgres from a different user. # Added "listen_addresses = '*'" in the file below
Sudo firewall-cmd -zone=public -add-port=5432/tcp -permanent # success Sudo /usr/pgsql-11/bin/postgresql-11-setup initdbĪfter the above steps, I did the following steps to make the postgres server accessible remotely.
# Initialise the database and enable automatic start So I've followed the instructions on the PostgreSQL download page and started running a PostgreSQL server running on port 5432 of my CentOS 7 VM. I wanted to be as detailed as possible to make it easier to spot a problem.
0 kommentar(er)
