Add clearly-defined vm role to access the staging clearly defined db instance
This installs the necessary cogs to access the particular clearly_defined db instance.
$ psql service=staging-clearly-defined # guest user, read-only access
$ psql service=admin-staging-clearly-defined # clearly-define user access read/write access to the db schema
inventory [1] updated
Related to T2865
Test Plan
vagrant up staging-clearly-defined
.pg_service.conf and .pgpass configured:
$ tg1999@clearly-defined:~$ cat .pg_service.conf
# This file is managed by puppet. Local modifications will be overwritten.
[clearly-defined]
dbname=clearly_defined
host=db1.internal.staging.swh.network
port=5432
user=guest
[admin-clearly-defined]
dbname=clearly_defined
host=db1.internal.staging.swh.network
port=5432
user=guest
tg1999@clearly-defined:~$ ls -lah .pgpass
-r-------- 1 tg1999 tg1999 288 Dec 16 12:31 .pgpass
Migrated from D4753 (view on Phabricator)