Can you give all the commands you ran and any relevant contextual information or files for reproducing the issue

I don't see anything unusual for a basic start up

$ docker run --rm -d -e MYSQL_ROOT_PASSWORD=root --name postgres postgres
$ docker exec -it postgres bash
root@ee08447db7b7:/# psql -U postgres
psql (10.4 (Debian 10.4-2.pgdg90+1))
Type "help" for help.

postgres=#

logs

$ docker logs postgres
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 default max_connections ... 100                                                                                                                     
selecting default shared_buffers ... 128MB                                                                                                                    
selecting dynamic shared memory implementation ... posix                                                                                                      
creating configuration files ... ok                                                                                                                           
running bootstrap script ... ok                                                                                                                               
performing post-bootstrap initialization ... ok                                                                                                               
syncing data to disk ... ok                                                                                                                                   
                                                                                                                                                              
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.

Success. You can now start the database server using:

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

****************************************************
WARNING: No password has been set for the database.
         This will allow anyone with access to the
         Postgres port to access your database. In
         Docker's default configuration, this is
         effectively any other container on the same
         system.

         Use "-e POSTGRES_PASSWORD=password" to set
         it in "docker run".
****************************************************
waiting for server to start....2018-09-11 18:26:56.933 UTC [51] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2018-09-11 18:26:56.989 UTC [52] LOG:  database system was shut down at 2018-09-11 18:26:55 UTC
2018-09-11 18:26:57.016 UTC [51] LOG:  database system is ready to accept connections
 done
server started
ALTER ROLE


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

waiting for server to shut down...2018-09-11 18:26:57.824 UTC [51] LOG:  received fast shutdown request
.2018-09-11 18:26:57.830 UTC [51] LOG:  aborting any active transactions
2018-09-11 18:26:57.835 UTC [51] LOG:  worker process: logical replication launcher (PID 58) exited with exit code 1
2018-09-11 18:26:57.837 UTC [53] LOG:  shutting down
2018-09-11 18:26:57.905 UTC [51] LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

2018-09-11 18:26:57.963 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2018-09-11 18:26:57.963 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2018-09-11 18:26:57.970 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2018-09-11 18:26:58.018 UTC [69] LOG:  database system was shut down at 2018-09-11 18:26:57 UTC
2018-09-11 18:26:58.047 UTC [1] LOG:  database system is ready to accept connections

Role postgres is missing #497

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions