Can't connect to PostgreSQL database - need help

[thesoloist]

I have partdb and PostgreSQL hosted in separate LXC containers (created with proxmox), and partdb keeps giving me the 500 error page with "infos for admin: Error while executing database query".

My DATABASE_URL in .env.local is set to:
DATABASE_URL="postgresql://partdb_user:[email protected]:5432/partdb_database?serverVersion=15.6&charset=utf8"

Running pg_isready from partdb container shows:
root@hxdai-ct-webapps:/var/www/partdb# pg_isready -d partdb_database -h hxdai-ct-postgresql.localdomain -p 5432 -U partdb_user hxdai-ct-postgresql.localdomain:5432 - accepting connections root@hxdai-ct-webapps:/var/www/partdb#
That suggests partdb container can connect to PostgreSQL server...

I'm quite new to Apache/PHP so please ask if I missed any important information. Thanks

[thesoloist]

Solved - the direct installation didn't have php8.2-pgsql as part of PHP installation (Debian 12 shipped with php8.2), and for the "Create a database for Part-DB" step, I misunderstood it, seeing the "migrations" leading me to think it's for copying from somewhere, rather than creating from scratch, so I ignored it (my mistake). Now it's up and running.