postgres DB doc: incorrectly states that password is not needed for (all) guest users
Heya, https://docs.softwareheritage.org/sysadm/data-silos/postgresql/howto-connect.html currently states:
The ~/.pgpass file is not needed for guest (read-only) access to databases. You will only need it for read-write access.
in my experience that is true for some databases, but not for others, which require a guest
password for the guest
user.
I haven't done a full swipe, but at least the swh-replica
service (postgresql-storage-replica
host) requires an explicit password when connecting to it from the VPN.
TIA Cheers