postgres | The files belonging to this database system will be owned by user "postgres". postgres | This user must also own the server process. postgres | postgres | The database cluster will be initialized with locale "en_US.utf8". postgres | The default database encoding has accordingly been set to "UTF8". postgres | The default text search configuration will be set to "english". postgres | postgres | Data page checksums are disabled. postgres | postgres | fixing permissions on existing directory /var/lib/postgresql/data ... ok postgres | creating subdirectories ... ok postgres | selecting dynamic shared memory implementation ... posix postgres | selecting default "max_connections" ... 100 postgres | selecting default "shared_buffers" ... 128MB postgres | selecting default time zone ... Etc/UTC postgres | creating configuration files ... ok postgres | running bootstrap script ... ok postgres | performing post-bootstrap initialization ... ok postgres | initdb: warning: enabling "trust" authentication for local connections postgres | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. postgres | syncing data to disk ... ok postgres | postgres | postgres | Success. You can now start the database server using: postgres | postgres | pg_ctl -D /var/lib/postgresql/data -l logfile start postgres | postgres | waiting for server to start....2026-06-29 12:25:21.273 UTC [47] LOG: starting PostgreSQL 17.7 (Debian 17.7-3.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit postgres | 2026-06-29 12:25:21.275 UTC [47] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" postgres | 2026-06-29 12:25:21.281 UTC [50] LOG: database system was shut down at 2026-06-29 12:25:20 UTC postgres | 2026-06-29 12:25:21.288 UTC [47] LOG: database system is ready to accept connections postgres | done postgres | server started postgres | postgres | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/db-pg.conf postgres | postgres | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/db-pg.sh postgres | #!/bin/bash -xv postgres | # Copyright (C) 2022,2024,2026 OpenInfra Foundation Europe. All rights reserved. postgres | # postgres | # Licensed under the Apache License, Version 2.0 (the "License"); postgres | # you may not use this file except in compliance with the License. postgres | # You may obtain a copy of the License at postgres | # postgres | # http://www.apache.org/licenses/LICENSE-2.0 postgres | # postgres | # Unless required by applicable law or agreed to in writing, software postgres | # distributed under the License is distributed on an "AS IS" BASIS, postgres | # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. postgres | # See the License for the specific language governing permissions and postgres | # limitations under the License. postgres | postgres | psql -U postgres -d postgres --command "CREATE USER ${PGSQL_USER} WITH PASSWORD '${PGSQL_PASSWORD}';" postgres | + psql -U postgres -d postgres --command 'CREATE USER policy_user WITH PASSWORD '\''policy_user'\'';' postgres | CREATE ROLE postgres | psql -U postgres -d postgres --command "CREATE DATABASE clampacm;" postgres | + psql -U postgres -d postgres --command 'CREATE DATABASE clampacm;' postgres | CREATE DATABASE postgres | psql -U postgres -d postgres --command "ALTER DATABASE clampacm OWNER TO ${PGSQL_USER} ;" postgres | + psql -U postgres -d postgres --command 'ALTER DATABASE clampacm OWNER TO policy_user ;' postgres | ALTER DATABASE postgres | psql -U postgres -d postgres --command "GRANT ALL PRIVILEGES ON DATABASE clampacm TO ${PGSQL_USER} ;" postgres | + psql -U postgres -d postgres --command 'GRANT ALL PRIVILEGES ON DATABASE clampacm TO policy_user ;' postgres | GRANT postgres | postgres | 2026-06-29 12:25:21.676 UTC [47] LOG: received fast shutdown request postgres | waiting for server to shut down....2026-06-29 12:25:21.677 UTC [47] LOG: aborting any active transactions postgres | 2026-06-29 12:25:21.679 UTC [47] LOG: background worker "logical replication launcher" (PID 53) exited with exit code 1 postgres | 2026-06-29 12:25:21.680 UTC [48] LOG: shutting down postgres | 2026-06-29 12:25:21.681 UTC [48] LOG: checkpoint starting: shutdown immediate postgres | 2026-06-29 12:25:21.793 UTC [48] LOG: checkpoint complete: wrote 934 buffers (5.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.063 s, sync=0.044 s, total=0.114 s; sync files=308, longest=0.006 s, average=0.001 s; distance=4260 kB, estimate=4260 kB; lsn=0/1916A78, redo lsn=0/1916A78 postgres | 2026-06-29 12:25:21.800 UTC [47] LOG: database system is shut down postgres | done postgres | server stopped postgres | postgres | PostgreSQL init process complete; ready for start up. postgres | postgres | 2026-06-29 12:25:21.913 UTC [1] LOG: starting PostgreSQL 17.7 (Debian 17.7-3.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit postgres | 2026-06-29 12:25:21.913 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 postgres | 2026-06-29 12:25:21.913 UTC [1] LOG: listening on IPv6 address "::", port 5432 postgres | 2026-06-29 12:25:21.921 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" postgres | 2026-06-29 12:25:21.926 UTC [70] LOG: database system was shut down at 2026-06-29 12:25:21 UTC postgres | 2026-06-29 12:25:21.931 UTC [1] LOG: database system is ready to accept connections postgres | 2026-06-29 12:25:43.331 UTC [105] ERROR: relation "databasechangelog" already exists postgres | 2026-06-29 12:25:43.331 UTC [105] STATEMENT: CREATE TABLE public.databasechangelog (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP WITHOUT TIME ZONE NOT NULL, ORDEREXECUTED INTEGER NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10)) postgres | 2026-06-29 12:27:17.427 UTC [106] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:27:17.427 UTC [106] DETAIL: Key (identificationid)=(dd36aaa4-580f-4193-a52b-37c3a955b11a) already exists. postgres | 2026-06-29 12:27:17.427 UTC [106] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:27:19.970 UTC [106] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:27:19.970 UTC [106] DETAIL: Key (identificationid)=(dd36aaa4-580f-4193-a52b-37c3a955b11a) already exists. postgres | 2026-06-29 12:27:19.970 UTC [106] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:27:30.675 UTC [144] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:27:30.675 UTC [144] DETAIL: Key (identificationid)=(dd36aaa4-580f-4193-a52b-37c3a955b11a) already exists. postgres | 2026-06-29 12:27:30.675 UTC [144] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:27:36.280 UTC [144] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:27:36.280 UTC [144] DETAIL: Key (identificationid)=(d30b8017-4d64-4693-84d7-de9c4226b9f8) already exists. postgres | 2026-06-29 12:27:36.280 UTC [144] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:27:58.629 UTC [144] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:27:58.629 UTC [144] DETAIL: Key (identificationid)=(d30b8017-4d64-4693-84d7-de9c4226b9f8) already exists. postgres | 2026-06-29 12:27:58.629 UTC [144] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:28:47.667 UTC [109] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:28:47.667 UTC [109] DETAIL: Key (identificationid)=(03dbb924-0265-4643-9936-7e159cc9d8b8) already exists. postgres | 2026-06-29 12:28:47.667 UTC [109] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:29:09.459 UTC [144] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:29:09.459 UTC [144] DETAIL: Key (identificationid)=(3add0828-1d68-4b87-8f19-e3df4fb3aa41) already exists. postgres | 2026-06-29 12:29:09.459 UTC [144] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:29:47.179 UTC [144] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:29:47.179 UTC [144] DETAIL: Key (identificationid)=(723a602b-f2dd-43b6-aad0-3d8f2749127c) already exists. postgres | 2026-06-29 12:29:47.179 UTC [144] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:30:22.026 UTC [68] LOG: checkpoint starting: time postgres | 2026-06-29 12:30:32.349 UTC [109] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:30:32.349 UTC [109] DETAIL: Key (identificationid)=(a8cdd644-2374-4155-b292-28fb75ca6706) already exists. postgres | 2026-06-29 12:30:32.349 UTC [109] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:30:46.113 UTC [68] LOG: checkpoint complete: wrote 243 buffers (1.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=24.067 s, sync=0.011 s, total=24.087 s; sync files=133, longest=0.002 s, average=0.001 s; distance=1348 kB, estimate=1348 kB; lsn=0/1A80408, redo lsn=0/1A67A98 postgres | 2026-06-29 12:31:03.771 UTC [109] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:31:03.771 UTC [109] DETAIL: Key (identificationid)=(a8cdd644-2374-4155-b292-28fb75ca6706) already exists. postgres | 2026-06-29 12:31:03.771 UTC [109] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:31:53.287 UTC [109] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:31:53.287 UTC [109] DETAIL: Key (identificationid)=(a8cdd644-2374-4155-b292-28fb75ca6706) already exists. postgres | 2026-06-29 12:31:53.287 UTC [109] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:32:09.613 UTC [144] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:32:09.613 UTC [144] DETAIL: Key (identificationid)=(a8cdd644-2374-4155-b292-28fb75ca6706) already exists. postgres | 2026-06-29 12:32:09.613 UTC [144] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:32:15.014 UTC [109] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:32:15.014 UTC [109] DETAIL: Key (identificationid)=(972daec3-00a5-41ca-88b2-290cbc09dcf1) already exists. postgres | 2026-06-29 12:32:15.014 UTC [109] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:32:27.026 UTC [144] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:32:27.026 UTC [144] DETAIL: Key (identificationid)=(972daec3-00a5-41ca-88b2-290cbc09dcf1) already exists. postgres | 2026-06-29 12:32:27.026 UTC [144] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:32:28.172 UTC [109] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:32:28.172 UTC [109] DETAIL: Key (identificationid)=(972daec3-00a5-41ca-88b2-290cbc09dcf1) already exists. postgres | 2026-06-29 12:32:28.172 UTC [109] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:32:29.313 UTC [144] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:32:29.313 UTC [144] DETAIL: Key (identificationid)=(972daec3-00a5-41ca-88b2-290cbc09dcf1) already exists. postgres | 2026-06-29 12:32:29.313 UTC [144] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:32:31.570 UTC [109] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:32:31.570 UTC [109] DETAIL: Key (identificationid)=(972daec3-00a5-41ca-88b2-290cbc09dcf1) already exists. postgres | 2026-06-29 12:32:31.570 UTC [109] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:32:47.800 UTC [144] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:32:47.800 UTC [144] DETAIL: Key (identificationid)=(c4da585b-17e2-423d-9035-371309633e49) already exists. postgres | 2026-06-29 12:32:47.800 UTC [144] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:32:56.638 UTC [109] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:32:56.638 UTC [109] DETAIL: Key (identificationid)=(c4da585b-17e2-423d-9035-371309633e49) already exists. postgres | 2026-06-29 12:32:56.638 UTC [109] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:33:26.080 UTC [109] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:33:26.080 UTC [109] DETAIL: Key (identificationid)=(723a602b-f2dd-43b6-aad0-3d8f2749127c) already exists. postgres | 2026-06-29 12:33:26.080 UTC [109] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3) postgres | 2026-06-29 12:33:36.896 UTC [144] ERROR: duplicate key value violates unique constraint "messagejob_identificationid_index" postgres | 2026-06-29 12:33:36.896 UTC [144] DETAIL: Key (identificationid)=(eb7cf5ec-ed7c-4ed2-b5de-73e11f8b5489) already exists. postgres | 2026-06-29 12:33:36.896 UTC [144] STATEMENT: insert into MessageJob (identificationId,jobStarted,jobId) values ($1,$2,$3)