Latest circleci/postgres:9.6-ram docker image is missing postgres role

postgresql

#1

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


#2

Made a response to this here: CircleCI Postgres Image suddenly causing problems? "role postgres not found"


#3

Thanks, followed solution (2) to fix the problem.