I have no idea how to configure that pg_hba.conf file, to connect with my server via pgAdmin. Right now i was trying to add:
host all all host.name.org.pl trust
host all all host.name.org.pl md5
host user_name database_name ip_adress trust
host all all ip_adress trust/md5
and others..
I've got a postgresql server. My provider says that i must connect by adress: sql.user_name.org.pl and 5432 port. There is no ssl on the server. I've got user and password. Can somebody please help me, to deal with this?
pg_hba.conf
file? Reloading the server afterwards? Either way, the server log file normally has detailed messages, why a connection attempt was denied. If nothing's there, you didn't even reach the right Postgres instance. And read the manual before tampering withpg_hba.conf
.pg_ctlcluster <pg_version> <cluster_name> reload
. Basic tool:pg_ctl
- read the manual where I linked to. But you need to run this as the system user that runs the server, usuallypostgres
. If this is a remote provider, I doubt you have the rights, and your provider will know how to get this done.