Ubuntu 18.04 & PostgreSQL 10.9: What do I fill in the Properties Form to Get Them to Connect?

Question

I have PostgreSQL 10.9 and Ubuntu localhost installed on my machine. I downloaded pgAdmin III on my machine for the first time.

I tried filling in the following based on a suggestion.

I get the following error:

Below is my config file:

Bruno Fernández · Answer 1 · 2019-08-06T18:35:37.730

1

You can try a basic connection filling these fields:

Name: a name of your connection (whatever in your mind) Host: 127.0.0.1 Port: by default is 5432 Username: postgres Password: password that you set during the initialization process

EDITED:

To solve the error in pg_hba.conf you need to add the following line in this file to allow users to connect via TCP using md5 encrypted passwords:

host all all 127.0.0.1 md5

This change requires a pg_reload_conf() signal. Use your terminal to access from psql command line: psql -U postgres

and execute the following sentence: SELECT pg_reload_conf();

If you can't access from psql, try to restart the service of PostgreSQL.

Try again from pgAdmin.

edited Aug 06 '19 at 18:35

answered Aug 06 '19 at 18:00

Bruno Fernández

11
4

thank you; is the host always 127.0.0.1 by default? – PineNuts0 Aug 06 '19 at 18:15
When I tried out your suggestion, I got the following error which I've appended to my original question – PineNuts0 Aug 06 '19 at 18:15
I edited my answer with your error. Please take a look. – Bruno Fernández Aug 06 '19 at 18:36

Ubuntu 18.04 & PostgreSQL 10.9: What do I fill in the Properties Form to Get Them to Connect?

1 Answers1