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