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.
As a first incremental step, i'll only reference the guest user (read-only access).
Shout out if we need also write access.