[issue] Error while running postgres:11-alpine

[roychowdhuryrohit-dev]

I am trying to run the following
docker run -d --rm \
--name authn-db \
-e POSTGRES_PASSWORD=abcd \
-e POSTGRES_USER=abcd \
postgres:11-alpine \
postgres

docker exec -it \
authn-db \
psql \
-h localhost \
-U postgres

However this results to psql: 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?

[wglambert]

The postgres user being implicitly created was a bug fixed in #493

Connecting using your created user abcd will work as expected

$ docker run -d --rm --name=authn-db -e POSTGRES_PASSWORD=abcd -e POSTGRES_USER=abcd postgres:11-alpine
Unable to find image 'postgres:11-alpine' locally
11-alpine: Pulling from library/postgres
4fe2ade4980c: Pull complete 
08cf8c12f47e: Pull complete 
451b995b6a91: Pull complete 
8f1d036dbb6b: Pull complete 
d3287fb19082: Pull complete 
0dc43cc2ae3a: Pull complete 
6cbc63414019: Pull complete 
6338460eec51: Pull complete 
4ae934be7eb6: Pull complete 
Digest: sha256:ece00b3499e907f74e0ba1aea9f0d01c1fe1f6aafce9deec9f05bf08398e04cc
Status: Downloaded newer image for postgres:11-alpine
960dbfd164344403b0cb3cb64a5c437b9681585e7651e8cc096d654df3eca5c7

$ docker exec -it authn-db psql -U abcd
psql (11beta3)
Type "help" for help.

abcd=# \l
                             List of databases
   Name    | Owner | Encoding |  Collate   |   Ctype    | Access privileges 
-----------+-------+----------+------------+------------+-------------------
 abcd      | abcd  | UTF8     | en_US.utf8 | en_US.utf8 | 
 postgres  | abcd  | UTF8     | en_US.utf8 | en_US.utf8 | 
 template0 | abcd  | UTF8     | en_US.utf8 | en_US.utf8 | =c/abcd          +
           |       |          |            |            | abcd=CTc/abcd
 template1 | abcd  | UTF8     | en_US.utf8 | en_US.utf8 | =c/abcd          +
           |       |          |            |            | abcd=CTc/abcd
(4 rows)

abcd=#

[roychowdhuryrohit-dev]

The postgres user being implicitly created was a bug fixed in #498

Connecting using your created user abcd will work as expected

$ docker run -d --rm --name=authn-db -e POSTGRES_PASSWORD=abcd -e POSTGRES_USER=abcd postgres:11-alpine
Unable to find image 'postgres:11-alpine' locally
11-alpine: Pulling from library/postgres
4fe2ade4980c: Pull complete 
08cf8c12f47e: Pull complete 
451b995b6a91: Pull complete 
8f1d036dbb6b: Pull complete 
d3287fb19082: Pull complete 
0dc43cc2ae3a: Pull complete 
6cbc63414019: Pull complete 
6338460eec51: Pull complete 
4ae934be7eb6: Pull complete 
Digest: sha256:ece00b3499e907f74e0ba1aea9f0d01c1fe1f6aafce9deec9f05bf08398e04cc
Status: Downloaded newer image for postgres:11-alpine
960dbfd164344403b0cb3cb64a5c437b9681585e7651e8cc096d654df3eca5c7

$ docker exec -it authn-db psql -U abcd
psql (11beta3)
Type "help" for help.

abcd=# \l
                             List of databases
   Name    | Owner | Encoding |  Collate   |   Ctype    | Access privileges 
-----------+-------+----------+------------+------------+-------------------
 abcd      | abcd  | UTF8     | en_US.utf8 | en_US.utf8 | 
 postgres  | abcd  | UTF8     | en_US.utf8 | en_US.utf8 | 
 template0 | abcd  | UTF8     | en_US.utf8 | en_US.utf8 | =c/abcd          +
           |       |          |            |            | abcd=CTc/abcd
 template1 | abcd  | UTF8     | en_US.utf8 | en_US.utf8 | =c/abcd          +
           |       |          |            |            | abcd=CTc/abcd
(4 rows)

abcd=#

Alright thanks. The problem was that there should be a delay between the two commands. Running them individually instead of a single shell script seemed to have done the trick.

[roychowdhuryrohit-dev]

Do you have any idea how can I run the 2 commands together without getting an error like Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432 ?
It seems psql is trying connect before the database server gets ready !

[wglambert]

If you ask me I would do a basic sleep on it just for now, if it has a longer initialize time you could do some checking if the image is able to accept connections, for that see healthcheck examples for one possible option of handling that https://github.com/docker-library/healthcheck

$ docker run -dit --rm --name=authn-db -e POSTGRES_PASSWORD=abcd -e POSTGRES_USER=abcd postgres:11-alpine; sleep 3; docker exec -it authn-db psql -U abcd
155db41ea6abcaf607073d437df08a4455fd60c1739547f9890adaadbc01bb5c
psql (11beta3)
Type "help" for help.

abcd=#

You could also try asking the Docker Community Forums, the Docker Community Slack, or Stack Overflow.