search

sameersbn / docker-postgresql

Dockerfile to build a PostgreSQL container image which can be linked to other containers.
MIT License
1.05k stars 467 forks source link

Error when starting #98

Closed borgdrone7 closed 7 years ago

borgdrone7 commented 7 years ago

Hi I get this when starting:

Initializing datadir... Initializing certdir... Initializing logdir... Initializing rundir... Setting resolv.conf ACLs... Initializing database... Configuring hot standby... ‣ Setting postgresql.conf parameter: wal_level = 'hot_standby' ‣ Setting postgresql.conf parameter: max_wal_senders = '16' ‣ Setting postgresql.conf parameter: checkpoint_segments = '8' ‣ Setting postgresql.conf parameter: wal_keep_segments = '32' ‣ Setting postgresql.conf parameter: hot_standby = 'on' ‣ Setting postgresql.conf parameter: data_directory = '/var/lib/postgresql/9.6/main' ‣ Setting postgresql.conf parameter: log_directory = '/var/log/postgresql' ‣ Setting postgresql.conf parameter: log_filename = 'postgresql-9.6-main.log' ‣ Setting postgresql.conf parameter: ssl = 'off' Creating database user: xpreso Creating database: geoagent... ‣ Loading fuzzystrmatch extension... ‣ Loading pg_trgm extension... ‣ Granting access to xpreso user... Starting PostgreSQL 9.6... LOG: database system was shut down at 2017-03-15 13:59:24 UTC LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections LOG: autovacuum launcher started ERROR: permission denied for relation pg_authid STATEMENT: SELECT a.oid,a.* FROM pg_catalog.pg_authid a ORDER BY a.oid

Also user and db are not created. I specified DB_PASS, DB_USER, DB_NAME in yml.