>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #3118243. --> Reported by: [daffie](https://www.drupal.org/user/116368) >>> <h3 id="summary-problem-motivation">Problem/Motivation</h3> <p><span class="drupalorg-gitlab-issue-link project-issue-status-info project-issue-status-7"><a href="https://www.drupal.org/project/drupal/issues/2846994" title="Status: Closed (fixed)">#2846994: Increase minimum version requirement for Postgres to 10 and require the pg_trgm extension</a></span> showed we to have the testbot run with Postgresql 10.</p> <h3 id="summary-proposed-resolution">Proposed resolution</h3> <p>1. Add db/pgsql-10.12 environment with postgresql-contrib package with pg_tgrm extension<br> 2. Add "testing_fake" schema to all pgsql containers.</p> <h3 id="summary-remaining-tasks">Remaining tasks</h3> <ul> <li>Manual testing/Review</li> </ul> <h3 id="summary-manual-testing">Manual testing</h3> <h4>Setup inside a drupalci vagrant VM</h4> <ol> <li>Clone drupalci_environments</li> <li>Apply the patch inside of it</li> <li>cd ~/drupalci_environments/db/pgsql-10.12</li> <li>docker build . (if successful, this will return a line like "Successfully built 7d7cfc3ec4ac")</li> <li>docker tag 7d7cfc3ec4ac drupalci/pgsql-10.12 (7d7cfc3ec4ac comes from the previous line)</li> <li>Pull some other containers like drupalci/pgsql-9.5 and drupalci/pgsql-9.1</li> </ol> <h4>Manually Test schema and extension output</h4> <p>Needs drupalci/pgsql-9.1 and drupalci/pgsql-9.5 pulled first.</p> <pre>for IMAGE in 9.1 9.5 10.12 ; do<br>docker run -d&nbsp; drupalci/pgsql-${IMAGE} ;<br>sleep 20;<br>docker exec -ti $(docker ps -q) psql -d drupaltestbot -c 'SELECT nspname FROM pg_catalog.pg_namespace;' ;<br>docker exec -ti $(docker ps -q) psql -d drupaltestbot -c 'CREATE EXTENSION pg_trgm;' ;<br>docker rm -f $(docker ps -q) ;<br>done</pre><p>The output for those exec commands should look like this given 9.1 (-), 9.5 (-1), and 10.12 (+)</p> <pre>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nspname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>--------------------<br> pg_toast<br> pg_temp_1<br> pg_toast_temp_1<br> pg_catalog<br> public<br> information_schema<br>+ drupal<br>-(6 rows)<br>-(6 rows)<br>+(7 rows)</pre><p>and</p> <pre>- ERROR:&nbsp; could not open extension control file "/usr/share/postgresql/9.1/extension/pg_tgrm.control": No such file or directory<br>- ERROR:&nbsp; could not open extension control file "/usr/share/postgresql/9.5/extension/pg_tgrm.control": No such file or directory<br>+ CREATE EXTENSION</pre><h4>Manually test drupalci itself</h4> <ol> <li>Comment out ~/testrunner/src/DrupalCI/Build/Environment/Environment::pull() from line 365 to 381 because the new image cannot be pulled from docker hub.</li> <li>Create a development.yml file. This development.yml should run some of the test groups like Database and uses the pgsql-10.12 environment. Example attached in comment <span class="drupalorg-gitlab-issue-link drupalorg-gitlab-link-wrapper"><a href="https://git.drupalcode.org/project/drupalci_environments/-/work_items/3104007" class="drupalorg-gitlab-link">https://git.drupalcode.org/project/drupalci_environments/-/work_items/3104007</a></span>.</li> <li>Change directory to ~/testrunner</li> <li>Watch them all fail when running ./drupalci run /path/to/development.yml because of the 10.12 issue.</li> </ol> <h3 id="summary-release-notes">Release notes snippet</h3> <p>drupalci now has a PostgreSQL 10.12 database environment. This environment has the pg_tgrm extension available to install. This functionality should not be relied upon as an available dependency when developing database features in Drupal core or contrib. All PostgreSQL database environments on drupalci now include a schema within the drupaltestbot database called "testing_fake" to be used for testing only. </p> > Related issue: [Issue #2846994](https://www.drupal.org/node/2846994) > Related issue: [Issue #3054376](https://www.drupal.org/node/3054376)