Configure db1 as new staging db server

We want to aligned the staging db as closed as possible than the production server

The following datasets will be configured configured :

• (already created) Dataset /data/postgres-main-12 mount on /srv/softwareheritage/postgres/12/main (postgresql:5433)
  • softwareheritage
• Dataset /data/postgres-secondary-12 mount on /srv/softwareheritage/postgres/12/secondary (postgresql:5434)
  • swh-vault
  • swh-lister
  • softwareheritage-scheduler
  • softwareheritage-deposit
• Dataset data/postgres-indexer-12 mounted on /srv/softwareheritage/postgres/12/indexer (postgresql:5435) [1]
  • softwareheritage-indexer

• [1] On production the indexer is using postgresql 11 at the moment

• Puppet
  • change the db0.internal.staging.swh.network node to use a wildcard selector
  • configure the new database node as the db host for the swh services

---

Migrated from T2736 (view on Phabricator)