PostgreSQL database name leads to database not found exception
>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #3382849. --> Reported by: [fjgarlin](https://www.drupal.org/user/2495842) Related to !39 >>> <h3 id="summary-problem-motivation">Problem/Motivation</h3> <p>The value of the the PostgreSQL database is set to: <code>POSTGRES_DB: pgsql</code><br> However, the images seem to create a database with the name <code>drupaltestbot</code>, see here: <a href="https://git.drupalcode.org/project/drupalci_environments/-/blob/dev/db/pgsql-13.5/conf/startup.sh#L22">https://git.drupalcode.org/project/drupalci_environments/-/blob/dev/db/pgsql-13.5/conf/startup.sh#L22</a></p> <p>This leads to errors when trying to use the posgres database.</p> <h4 id="summary-steps-reproduce">Steps to reproduce</h4> <p>Before: <a href="https://git.drupalcode.org/project/gitlab_ci_testbed_for_drupal_core/-/jobs/69227">https://git.drupalcode.org/project/gitlab_ci_testbed_for_drupal_core/-/jobs/69227</a></p> <blockquote><p>SQLSTATE[08006] [7] FATAL: database "pgsql" does not exist</p></blockquote> <h3 id="summary-proposed-resolution">Proposed resolution</h3> <p>After: <a href="https://git.drupalcode.org/project/gitlab_ci_testbed_for_drupal_core/-/jobs/69263">https://git.drupalcode.org/project/gitlab_ci_testbed_for_drupal_core/-/jobs/69263</a><br> The change was this: <a href="https://git.drupalcode.org/project/gitlab_ci_testbed_for_drupal_core/-/merge_requests/5/diffs?commit_id=a36ba032645f249f77c7f082494b2adface4255a">https://git.drupalcode.org/project/gitlab_ci_testbed_for_drupal_core/-/merge_requests/5/diffs?commit_id=a36ba032645f249f77c7f082494b2adface4255a</a><br> <code>POSTGRES_DB: drupaltestbot</code></p> <h3 id="summary-remaining-tasks">Remaining tasks</h3> <p>MR</p>
issue