Hi,
The latest circleci/postgres:9.6-ram docker image (circleci/postgres@sha256:3ed62672b3e7bd540c3556614c4bc286b584af10aaec43cfc05bc2cf44172b03)
Has been changed, it’s no longer running the “create role postgres;” statement
The previous images did (e.g.
circleci/postgres@sha256:8f299c1eb8c7148c89db7d8667194b9eeb5b3ee4944dbc1211f909fd359907b5)
Output of latest docker image startup:
Success. You can now start the database server using:
pg_ctl -D /dev/shm/pgdata/data -l logfile start
waiting for server to start…LOG: database system was shut down at 2018-09-11 13:44:43 UTC
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
done
server started
CREATE DATABASE
/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
LOG: received fast shutdown request
LOG: aborting any active transactions
waiting for server to shut down…LOG: autovacuum launcher shutting down
.LOG: shutting down
LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
LOG: database system was shut down at 2018-09-11 13:44:45 UTC
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
FATAL: role “postgres” does not exist
FATAL: role “postgres” does not exist
FATAL: role “postgres” does not exist
Previous docker image log output:
Success. You can now start the database server using:
pg_ctl -D /dev/shm/pgdata/data -l logfile start
waiting for server to start…LOG: database system was shut down at 2018-09-07 14:03:05 UTC
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
done
server started
CREATE DATABASE
CREATE ROLE
/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
LOG: received fast shutdown request
waiting for server to shut down…LOG: aborting any active transactions
LOG: autovacuum launcher shutting down
.LOG: shutting down
LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
LOG: database system was shut down at 2018-09-07 14:03:07 UTC
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
Please could the docker image maintainer check what’s happened to the role create statement?
Thanks
Dan