S
S
Stepan Sidorov2020-05-13 14:03:01
PostgreSQL
Stepan Sidorov, 2020-05-13 14:03:01

How to set up a server on pgadmin?

When creating a server on pgadmin, I encounter an error:

Unable to connect to server:

could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?

Here is a screenshot if anyone does not understand where and how I do it 5ebbd3b8785d7883933394.png:.
The question is short rather short, how to create a server?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
S
Stepan Sidorov, 2020-05-13
@Stepan47

First you need to create a postgress database (or another), create a user on it, and connect it to pgadmin.

D
d-stream, 2020-05-13
@d-stream

pgadmin - a simplified "program" for managing an [already running] server
, that is, at least you need to install and run postgresql using OS tools, at least with minimal settings (login, password)

W
Winny63, 2022-04-21
@Winny63

Similar problem:
The PG server is running on the host. A docker container with pgAdmin is running on the same host.
In the interactive on PG, a postgres client / password and a postgres database were created (as the books ask)
In the server config, the listener is rewritten to "*".
An additional virtual network has been created on the docker and the pgadmin container is attached to it.
The IP of the host from the container is being pinged...
pgAdmin is not connecting to the database.
62618c2ecfe42920128666.png
What other options are there?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question