Skip to content

Allow simple read-only connections to db from swh nodes

Our current recommended pg_service setup to connect to the DB replica is:

[swh-replica]
dbname=softwareheritage
host=somerset.internal.softwareheritage.org
user=guest
port=5433

But that needs one swh user to actually setup manually such file (and also be aware of what's what). We should puppetize this and install it by default on our swh nodes so that user can simply execute:

swhuser@swhnode $ psql service=swh-replica

for example to connect to the db replica. Related #1234 (closed)

Note: As a first incremental step, i'll only reference the guest user (read-only access). Shout out if we need also write access.


Migrated from T1234 (view on Phabricator)

Edited by Antoine R. Dumont