Cannot connect to the postgres in docker container

[GrzesiuKo]

Today I pulled the newest image of postgres:
docker pull postgres
And started container out of it:
docker run --rm --name pg-docker -e POSTGRES_PASSWORD=docker -d -p 5432:5432 postgres
After that I tried to access the postgres:
psql -h localhost -U postgres -d postgres
And connection failed:
psql: error: could not connect to server: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

All the instructions I did according to the repositories documentation.

[wglambert]

Perhaps your database wasn't fully initialized yet?

I'm not able to reproduce
(192.168.0.8 is the host's IP, so the connection is [container]->[host]->[container]

$ docker run --rm --name pg-docker -e POSTGRES_PASSWORD=docker -d -p 5432:5432 postgres
2b53de444c7e9b8c84039159c37c04be06c743cb3941359a17f8f769beb28c9e

$ docker run -it --rm postgres bash
root@64564e59b3fc:/# psql -h 192.168.0.8 -U postgres -d postgres
Password for user postgres: 
psql (12.2 (Debian 12.2-2.pgdg100+1))
Type "help" for help.

postgres=#

What do your docker logs show?

[GrzesiuKo]

It looks like database is up and running, however I still get the same error :/
Docker logs:

$ docker logs 0962a7922df8
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok


Success. You can now start the database server using:
pg_ctl -D /var/lib/postgresql/data -l logfile start

initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
waiting for server to start....2020-03-19 08:08:33.782 UTC [44] LOG:  starting PostgreSQL 12.2 (Debian 12.2-2.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2020-03-19 08:08:33.783 UTC [44] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-03-19 08:08:33.806 UTC [45] LOG:  database system was shut down at 2020-03-19 08:08:33 UTC
2020-03-19 08:08:33.813 UTC [44] LOG:  database system is ready to accept connections
 done
server started

/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

2020-03-19 08:08:33.862 UTC [44] LOG:  received fast shutdown request
waiting for server to shut down...2020-03-19 08:08:33.863 UTC [44] LOG:  aborting any active transactions
2020-03-19 08:08:33.873 UTC [44] LOG:  background worker "logical replication launcher" (PID 51) exited with exit code 1
2020-03-19 08:08:33.873 UTC [46] LOG:  shutting down
.2020-03-19 08:08:33.891 UTC [44] LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

2020-03-19 08:08:34.039 UTC [1] LOG:  starting PostgreSQL 12.2 (Debian 12.2-2.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2020-03-19 08:08:34.039 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2020-03-19 08:08:34.039 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2020-03-19 08:08:34.042 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-03-19 08:08:34.063 UTC [53] LOG:  database system was shut down at 2020-03-19 08:08:33 UTC
2020-03-19 08:08:34.071 UTC [1] LOG:  database system is ready to accept connections

I am running this with Docker Toolbox on Windows 10 Pro.
And I am trying to connect [host]->[container].
I also tried as You did [container]->[host]->[container], but it failed aswell.

[GrzesiuKo]

Are You sure You don't have postgresql-x64-12 service running, while trying to reproduce it?
It is also on port 5432 by default.

[GrzesiuKo]

I tried on Ubuntu 18.04.4 LTS and it works fine, however I don't know how to run it on Windows :/

[GrzesiuKo]

Alright I found the solution, I should have used this IP as Docker Toolbox runs in VM.
Thank You for Your help.

[bonchovylkov]

Are You sure You don't have postgresql-x64-12 service running, while trying to reproduce it?
It is also on port 5432 by default.

Dude, you saved me!