Question : Whatever settings I try, I keep getting connection errors, from external clients as well as trying to connect […]
Tag: pg-hba.conf
Access to database denied :ELEPHANTSQL on Bluemix – “No pg_hba.conf entry for host localhost, user ADMIN, database SYSTEM”
Question : While trying to connect to my ElephantSQL database on Bluemix using pgadmin, it throws the following error. Access […]
script breaks my ability to run psql
Question : I’ve successfully installed postgres on my Ubuntu machine. I am running a script for a website I am […]
How do I enable md5 authentication for only one user?
Question : I just installed Postgres 9.2 on CentOS 7. I want to keep peer authentication for all my users […]
pg_hba error while setting up repmgr
Question : Please help me to figure it out, help is much appreciated! ERROR: FATAL: no pg_hba.conf entry for replication […]
psql: FATAL: Peer authentication failed for user
Question : I just installed PostgreSQL 9.4 on Ubuntu 15.10. I created a user with createuser -P myuser I created […]
ALTER USER postgres PASSWORD null; now has locked me out of psql
Question : I have installed postgresql version 9.3.14 on High Sierra via HomeBrew. Upon trying to access the server via […]
I Need Help Setting Up Roles and Passwords in PostgreSQL
Question : I’m using the postgres.app on my Mac Mini Server running version 9.4.0 using El Capitan. I have not […]
pg_hba.conf from PostgreSQL
Question : I have no idea how to configure that pg_hba.conf file, to connect with my server via pgAdmin. Right […]
How to restart PostgreSQL server under CentOS 7
Question : 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), […]