Postgres automated Travis CI test fails due to drush postgres site-install fail

[geerlingguy]

Issue Type

• Bug Report / Support Request

Full console output

TASK [geerlingguy.drupal : Install Drupal with drush.] *************************
fatal: [localhost]: FAILED! => {"changed": true, "cmd": ["/var/www/drupalvm/drupal/vendor/drush/drush/drush", "site-install", "standard", "-y", "--root=/var/www/drupalvm/drupal/web", "--site-name=Drupal", "--account-name=admin", "--account-pass=admin", "--db-url=pgsql://drupal:drupal@localhost/drupal"], "delta": "0:00:00.385153", "end": "2018-01-29 22:34:15.979946", "msg": "non-zero return code", "rc": 1, "start": "2018-01-29 22:34:15.594793", "stderr": " [error]  Failed to create database: Password for user drupal:psql: fe_sendauth: no password supplied ", "stderr_lines": [" [error]  Failed to create database: Password for user drupal:psql: fe_sendauth: no password supplied "], "stdout": "\n // You are about to DROP all tables in your 'drupal' database. Do you want to  \n // continue?: yes.                                                             ", "stdout_lines": ["", " // You are about to DROP all tables in your 'drupal' database. Do you want to  ", " // continue?: yes.                                                             "]}

Specifically:

$ /var/www/drupalvm/drupal/vendor/drush/drush/drush site-install standard -y --root=/var/www/drupalvm/drupal/web --site-name=Drupal --account-name=admin --account-pass=admin --db-url=pgsql://drupal:drupal@localhost/drupal
...
[error]  Failed to create database: Password for user drupal:psql: fe_sendauth: no password supplied

Summary

Basically, see drush-ops/drush#3330 — it looks like it's an upstream Drush issue (that has reared its head in the past), and we might have to resort to some environment variable-based hack as described in this comment to fix the problem :(

[geerlingguy]

Apparently this was fixed upstream in drush-ops/drush#3480; once the next stable Drush release comes out, we should be able to test postgres again.

[nbertram]

@geerlingguy if there's any further issues with getting Drush tests working properly with Postgres I'm happy to help out. It's in our best interests here!

[stale]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark issues as stale.

[geerlingguy]

I think this can be fixed now.

[stale]

This issue is no longer marked for closure.

[geerlingguy]

Hooray, tests are working again!