Cannot connect to postgresql on port 5432

Поиск
Список
Период
Сортировка

Hi Experts,

 

Post installation of  PostgreSQL it is not listening on an IP, only on localhost.

 

Please suggest your inputs.

 

 

Used below command for installations –

 

# apt-get install postgresql-12

postgres=# select version();

                                                     version

------------------------------------------------------------------------------------------------------------------

PostgreSQL 12.1 (Debian 12.1-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit

(1 row)

 

Entries in ::: /etc/postgresql/12/main/pg_hba.conf

# Database administrative login by Unix domain socket

local   all             postgres                                peer

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only

local   all             all                                     peer

# IPv4 local connections:

host    all             all             127.0.0.1/32            md5

# IPv6 local connections:

host    all             all             ::1/128                 md5

# Allow replication connections from localhost, by a user with the

# replication privilege.

local   replication     all                                     peer

host    replication     all             127.0.0.1/32            md5

host    replication     all             ::1/128                 md5

 

Not connected

 

postgres@srv:/opt$ netstat -nlp | grep 5432

(Not all processes could be identified, non-owned process info

will not be shown, you would have to be root to see it all.)

tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      25857/postgres

unix  2      [ ACC ]     STREAM     LISTENING     74234    25857/postgres       /var/run/postgresql/.s.PGSQL.5432

 

 

postgres@srv:~$ telnet 10.133.214.32 5432

Trying 10.133.214.32...

telnet: Unable to connect to remote host: Connection refused

 

 

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: Partitioning by month causing an error?
Следующее
От: gilberto.castillo@etecsa.cu
Дата:
Сообщение: Re: [MASSMAIL]Cannot connect to postgresql on port 5432