Centos pgconfig issue

[musasutisna]

I encountered an error while deploying to a server running CentOS Rocky Linux 8.9 (Green Obsidian). The process failed when attempting to run pgconfigdb, and the following log was generated:

The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

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
performing post-bootstrap initialization ... ok
syncing data to disk ... ok


Success. You can now start the database server using:

    pg_ctl -D /var/lib/postgresql/data -l logfile start

initdb: warning: enabling "trust" authentication for local connections
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.
waiting for server to start....2024-09-11 04:06:48.382 UTC [89] LOG:  starting PostgreSQL 16.4 (Debian 16.4-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
2024-09-11 04:06:48.393 UTC [89] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-09-11 04:06:48.448 UTC [99] LOG:  database system was shut down at 2024-09-11 04:06:47 UTC
2024-09-11 04:06:48.465 UTC [100] FATAL:  the database system is starting up
2024-09-11 04:06:48.478 UTC [89] LOG:  database system is ready to accept connections
 done
server started
2024-09-11 04:06:53.679 UTC [116] FATAL:  database "pgconfig" does not exist
CREATE DATABASE


/usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh