Skip to content

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)

Merge request reports