okfn / docker-ckan

Docker images and Docker Compose setup for CKAN [Not Maintained]
GNU Affero General Public License v3.0
81 stars 91 forks source link

readme.md doc inconsistent with docker-ckan/postgresql/Dockerfile #14

Closed terchris closed 6 years ago

terchris commented 6 years ago

In README.md it says: PostgresSQL: mdillon's PostGIS image

In the docker-ckan/postgresql/Dockerfile it is not used.

sirex commented 6 years ago

I tried to use mdillon/postgis:9.6-alpine image, but for some reason user table is not created.

ckan-dev_1    | [prerun] Initializing or upgrading db - start
db            | ERROR:  relation "user" does not exist at character 465
db            | STATEMENT:  SELECT "user".password AS user_password, "user".id AS user_id, "user".name AS user_name, "user".openid AS user_openid, "user".fullname AS user_fullname, "user".email AS user_email, "user".apikey AS user_apikey, "user".created AS user_created, "user".reset_key AS user_reset_key, "user".about AS user_about, "user".activity_streams_email_notifications AS user_activity_streams_email_notifications, "user".sysadmin AS user_sysadmin, "user".state AS user_state
db            |         FROM "user"
db            |         WHERE "user".name = 'default' OR "user".id = 'default' ORDER BY "user".name
db            |          LIMIT 1

@amercader maybe you have an idea, why this could happen?

amercader commented 6 years ago

@terchris thanks, fixed now

@sirex Could it be because of this issue with the PostGIS images discussed in CKAN core?

https://github.com/ckan/ckan/issues/3929 https://github.com/ckan/ckan/pull/4026