ERROR: Error message being thrown in docker logs

[joewxboy]

Error: Database is uninitialized and superuser password is not specified.
       You must specify POSTGRES_PASSWORD to a non-empty value for the
       superuser. For example, "-e POSTGRES_PASSWORD=password" on "docker run".

       You may also use "POSTGRES_HOST_AUTH_METHOD=trust" to allow all
       connections without a password. This is *not* recommended.

       See PostgreSQL documentation about "trust":
       https://www.postgresql.org/docs/current/auth-trust.html

[t-fine]

need to set this PASSWORD env var to the secret value:

service-postgresql/horizon/deployment.policy.json

Line 34 in bbefcd2

"secrets": [

service-postgresql/horizon/service.definition.json

Line 20 in bbefcd2

"secrets": {"secret_user":{},"secret_password":{},"secret_db":{}}

[joewxboy]

New error:

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default "max_connections" ... 100
selecting default "shared_buffers" ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
2025-04-09 19:28:39.050 UTC [40] FATAL:  syntax error at or near "key" at character 15
2025-04-09 19:28:39.050 UTC [40] STATEMENT:  ALTER USER "{"key":"user","value":"jpearson"}" WITH PASSWORD E'{"key":"password","value":"notapw"}';

child process exited with exit code 1
initdb: removing contents of data directory "/var/lib/postgresql/data"