Error connecting to Postgresql by pgAdmin 4

Asked

Viewed 6,599 times

1

I installed the pgAdmin 4 in my note with Windows 10 and I’m unable to access the database.

Host name/address = /198.22.33.44
Gate 5432
Maintenance Database = xxxxxx
Username = cesar_r
Password = ******
SSL mode = Prefer

The IP number is configured on pg_hba.conf as follows:

host all 198.22.33.44/32 password

At the address I place the IP number preceded by / (as stated in the documentation).
The database is installed on a Linux server (Ubuntu).

NOTE: I am trying to connect with a simple user with read-only permission.

postgresql pgadmin

  • What a mistake he accuses?

  • In pgAdmin 4 it is necessary to indicate the directory of the binaries, you did it? as already said that it is Windows 10 it is likely to be C:\Program Files\PostgreSQL\*versao*\bin. We need to know what the mistake is.

1 answer

1

Gave a job to run... but it is the following, after installing the pgAdmin4

At a cmd prompt (not git bash) go to the postgres directory

cd c:\Program Files\PostgreSQL\SUA_VERSAO\bin

Run the init

initdb -D "c:/Program Files/PostgreSQL/9.6/data"

Start pg by setting a directory for the log

pg_ctl -D "c:/Program Files/PostgreSQL/9.6/data" -l "C:/Users/SEU_USUARIO/logfile.log" start

Done. The user you used in the installation should be used to create the server in pgAdmin4

if you are in doubt about the registered user, type in the prompt:

createuser

It will inform the existing name.

Browser other questions tagged postgresql pgadmin

You are not signed in. Login or sign up in order to post.