Page MenuHomeSoftware Heritage

Deploy production swh-scrubber db connection
ClosedPublic

Authored by ardumont on Jun 24 2022, 4:10 PM.

Details

Summary

Related to T4324

Test Plan

Currently installed in pgbouncer.ini in belvedere and connection is ok.

octo-diff:

$ $SWH_PUPPET_ENVIRONMENT_HOME/bin/octocatalog-diff --octocatalog-diff-args --no-truncate-details --to staging belvedere
Found host belvedere.internal.softwareheritage.org
...
diff origin/production/belvedere.internal.softwareheritage.org current/belvedere.internal.softwareheritage.org
*******************************************
  Concat::Fragment[_postgres] =>
   parameters =>
     content =>
      @@ -7,4 +7,5 @@
       softwareheritage-indexer = host=belvedere.internal.softwareheritage.org port=5435 auth_user=postgres
       swh-web = host=belvedere.internal.softwareheritage.org port=5434 auth_user=postgres
      +swh-scrubber = host=db.internal.softwareheritage.org port=5434 auth_user=postgres
       * = host=127.0.0.1 port=5434 auth_user=postgres
      _
*******************************************
  Concat_fragment[_postgres] =>
   parameters =>
     content =>
      @@ -7,4 +7,5 @@
       softwareheritage-indexer = host=belvedere.internal.softwareheritage.org port=5435 auth_user=postgres
       swh-web = host=belvedere.internal.softwareheritage.org port=5434 auth_user=postgres
      +swh-scrubber = host=db.internal.softwareheritage.org port=5434 auth_user=postgres
       * = host=127.0.0.1 port=5434 auth_user=postgres
      _
*******************************************
  Pgbouncer::Databases[pgbouncer_module_databases] =>
   parameters =>
     databases =>
      - [{"source_db"=>"softwareheritage", "host"=>"belvedere.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5433"}, {"source_db"=>"softwareheritage-deposit", "host"=>"db.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5434"}, {"source_db"=>"softwareheritage-scheduler", "host"=>"db.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5434"}, {"source_db"=>"swh-vault", "host"=>"db.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5434"}, {"source_db"=>"swh-lister", "host"=>"db.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5434"}, {"source_db"=>"softwareheritage-indexer", "host"=>"belvedere.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5435"}, {"source_db"=>"swh-web", "host"=>"belvedere.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5434"}, {"source_db"=>"*", "host"=>"127.0.0.1", "auth_user"=>"postgres", "port"=>"5434"}]
      + [{"source_db"=>"softwareheritage", "host"=>"belvedere.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5433"}, {"source_db"=>"softwareheritage-deposit", "host"=>"db.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5434"}, {"source_db"=>"softwareheritage-scheduler", "host"=>"db.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5434"}, {"source_db"=>"swh-vault", "host"=>"db.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5434"}, {"source_db"=>"swh-lister", "host"=>"db.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5434"}, {"source_db"=>"softwareheritage-indexer", "host"=>"belvedere.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5435"}, {"source_db"=>"swh-web", "host"=>"belvedere.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5434"}, {"source_db"=>"swh-scrubber", "host"=>"db.internal.softwareheritage.org", "auth_user"=>"postgres", "port"=>"5434"}, {"source_db"=>"*", "host"=>"127.0.0.1", "auth_user"=>"postgres", "port"=>"5434"}]
*******************************************
*** End octocatalog-diff on belvedere.internal.softwareheritage.org

Diff Detail

Repository
rSPSITE puppet-swh-site
Lint
Automatic diff as part of commit; lint not applicable.
Unit
Automatic diff as part of commit; unit tests not applicable.