Problem:
When I run “docker-compose up -d” the container of postgress keeps restarting and throws endless errors.
docker logs -f <postgres_container>
2022-01-24 16:43:16.002 UTC [83] ERROR: relation "template_inputs" does not exist at character 454
2022-01-24 16:43:16.002 UTC [83] STATEMENT: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
c.collname, col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a
LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
WHERE a.attrelid = '"template_inputs"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
2022-01-24 16:43:16.002 UTC [83] ERROR: relation "template_inputs" does not exist at character 454
2022-01-24 16:43:16.002 UTC [83] STATEMENT: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
c.collname, col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a
LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
WHERE a.attrelid = '"template_inputs"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
2022-01-24 16:43:16.002 UTC [83] ERROR: relation "template_inputs" does not exist at character 454
2022-01-24 16:43:16.002 UTC [83] STATEMENT: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
c.collname, col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a
LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
WHERE a.attrelid = '"template_inputs"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
2022-01-24 16:43:16.005 UTC [83] ERROR: relation "permissions" does not exist at character 454
2022-01-24 16:43:16.005 UTC [83] STATEMENT: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
c.collname, col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a
LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
WHERE a.attrelid = '"permissions"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Expected outcome:
The environment should come up.
Foreman and Proxy versions:
- latest git
Foreman and Proxy plugin versions:
- latest git
Distribution and version:
- latest git
Other relevant data:
I assume I need to configure some environment variables. I can’t find any references in the documentation what I do need to configure in order for the docker-compose to work.