Not able to connect to alpine images

[nicoleepp]

$ docker run --detach -p 5432:5432 postgres:12-alpine

$ psql -h localhost -p 5432 -U postgres -d postgres -W 
psql: could not connect to server: Connection refused
	Is the server running on host "localhost" (::1) and accepting
	TCP/IP connections on port 5432?
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?

The above works for running just postgres though:

docker run --detach -p 5432:5432 postgres

[nicoleepp]

This started happening 12 days ago

[tianon]

If you check the logs on your container, I think you'll see this is a case of #681 😅

[nicoleepp]

It seems like the alpine images don't check for export POSTGRES_HOST_AUTH_METHOD=trust but require the password to be set?

docker run --detach -p 5432:5432 -e POSTGRES_PASSWORD=password postgres:12-alpine works but using POSTGRES_HOST_AUTH_METHOD=trust as an env variable gives the same error

[wglambert]

I'm not able to reproduce the issue

$ docker run -d --name postgres postgres:12-alpine                                                                                
ec60e47502de9d21158cb586be576f5716c4c6cdf9cde13a283c8eb4a74341e7

$ docker logs postgres                                                                                                            
Error: Database is uninitialized and superuser password is not specified.
       You must specify POSTGRES_PASSWORD to a non-empty value for the
       superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run".

       You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all
       connections without a password. This is *not* recommended.

       See PostgreSQL documentation about "trust":
       https://www.postgresql.org/docs/current/auth-trust.html

$ docker run -d --name postgres -e POSTGRES_HOST_AUTH_METHOD=trust postgres:12-alpine
ae282e52617f2127cafba3a6c3fac2d528e22b18249cbe6f4766d21c8338056a

$ docker logs -f postgres                            
********************************************************************************
WARNING: POSTGRES_HOST_AUTH_METHOD has been set to "trust". This will allow
         anyone with access to the Postgres port to access your database without
         a password, even if POSTGRES_PASSWORD is set. See PostgreSQL
         documentation about "trust":
         https://www.postgresql.org/docs/current/auth-trust.html
         In Docker's default configuration, this is effectively any other
         container on the same system.

         It is not recommended to use POSTGRES_HOST_AUTH_METHOD=trust. Replace
         it with "-e POSTGRES_PASSWORD=password" instead to set a password in
         "docker run".
********************************************************************************
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 ... UTC
creating configuration files ... ok
running bootstrap script ... ok
sh: locale: not found
2020-02-26 22:03:35.072 UTC [29] WARNING:  no usable system locales were found
performing post-bootstrap initialization ... ok
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.
syncing data to disk ... ok


Success. You can now start the database server using:

    pg_ctl -D /var/lib/postgresql/data -l logfile start

waiting for server to start....2020-02-26 22:03:38.250 UTC [34] LOG:  starting PostgreSQL 12.2 on x86_64-pc-linux-musl, compiled by gcc (Alpine 9.2.0) 9.2.0, 64-bit
2020-02-26 22:03:38.285 UTC [34] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-02-26 22:03:38.455 UTC [35] LOG:  database system was shut down at 2020-02-26 22:03:35 UTC
2020-02-26 22:03:38.503 UTC [34] LOG:  database system is ready to accept connections
 done
server started

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

waiting for server to shut down....2020-02-26 22:03:38.856 UTC [34] LOG:  received fast shutdown request
2020-02-26 22:03:38.890 UTC [34] LOG:  aborting any active transactions
2020-02-26 22:03:38.892 UTC [34] LOG:  background worker "logical replication launcher" (PID 41) exited with exit code 1
2020-02-26 22:03:38.892 UTC [36] LOG:  shutting down
2020-02-26 22:03:39.132 UTC [34] LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

2020-02-26 22:03:39.255 UTC [1] LOG:  starting PostgreSQL 12.2 on x86_64-pc-linux-musl, compiled by gcc (Alpine 9.2.0) 9.2.0, 64-bit
2020-02-26 22:03:39.256 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2020-02-26 22:03:39.256 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2020-02-26 22:03:39.324 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-02-26 22:03:39.445 UTC [43] LOG:  database system was shut down at 2020-02-26 22:03:39 UTC
2020-02-26 22:03:39.494 UTC [1] LOG:  database system is ready to accept connections
^C

$ docker exec -it postgres psql -U postgres
psql (12.2)
Type "help" for help.

postgres=#

[nicoleepp]

@wglambert thanks that does work.

I was assuming exporting it as an env variable would work

$ export POSTGRES_HOST_AUTH_METHOD=trust
$ docker run -d --name postgres postgres:12-alpine
77cca65f2c090957a6db96e9dff63e9ffff36e1f5ec9cf52324f7700709e5634            
$ docker logs postgres                                                                                                            
Error: Database is uninitialized and superuser password is not specified.
       You must specify POSTGRES_PASSWORD to a non-empty value for the
       superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run".

       You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all
       connections without a password. This is *not* recommended.

       See PostgreSQL documentation about "trust":
       https://www.postgresql.org/docs/current/auth-trust.html

[tianon]

Ah, nope; it has to be passed to the container explicitly with -e or --env. 😅

[nicoleepp]

Thanks all