bin/octocatalog [2]
`vagrant provision staging-db1` is fine and initialization steps (if worked
around [1] is fine, D4374 again)
[1] edit /usr/lib/.../swh/core/cli/db.py and comment out the create database part.
[2]
```
bin/octocatalog-diff --octocatalog-diff-args --no-truncate-details --to staging db0.internal.staging.swh.network
Found host db0.internal.staging.swh.network
WARN -> Environment "open-template1" contained non-word characters, correcting name to open_template1
Cloning into '/tmp/swh-ocd.Zr4sQYWJ/environments/production/data/private'...
done.
Cloning into '/tmp/swh-ocd.Zr4sQYWJ/environments/staging/data/private'...
done.
*** Running octocatalog-diff on host db0.internal.staging.swh.network
I, [2020-10-29T15:38:27.912536 #4321] INFO -- : Catalogs compiled for db0.internal.staging.swh.network
I, [2020-10-29T15:38:29.049652 #4321] INFO -- : Diffs computed for db0.internal.staging.swh.network
diff origin/production/db0.internal.staging.swh.network current/db0.internal.staging.swh.network
*******************************************
+ Postgresql::Server::Role[swh-admin] =>
parameters =>
"connect_settings": {}
"connection_limit": "-1"
"createdb": false
"createrole": false
"db": "postgres"
"ensure": "present"
"inherit": true
"login": true
"password_hash": "md5a1ef5366acf215ee76295ac28aa629f7"
"replication": false
"superuser": true
"update_password": true
"username": "swh-admin"
*******************************************
+ Postgresql_psql[ALTER ROLE "swh-admin" CONNECTION LIMIT -1] =>
parameters =>
"connect_settings": {}
"cwd": "/tmp"
"db": "postgres"
"port": 5433
"psql_group": "postgres"
"psql_path": "/usr/bin/psql"
"psql_user": "postgres"
"unless": "SELECT 1 FROM pg_roles WHERE rolname = 'swh-admin' AND rolconnlimit = -1"
*******************************************
+ Postgresql_psql[ALTER ROLE "swh-admin" INHERIT] =>
parameters =>
"connect_settings": {}
"cwd": "/tmp"
"db": "postgres"
"port": 5433
"psql_group": "postgres"
"psql_path": "/usr/bin/psql"
"psql_user": "postgres"
"unless": "SELECT 1 FROM pg_roles WHERE rolname = 'swh-admin' AND rolinherit = true"
*******************************************
+ Postgresql_psql[ALTER ROLE "swh-admin" LOGIN] =>
parameters =>
"connect_settings": {}
"cwd": "/tmp"
"db": "postgres"
"port": 5433
"psql_group": "postgres"
"psql_path": "/usr/bin/psql"
"psql_user": "postgres"
"unless": "SELECT 1 FROM pg_roles WHERE rolname = 'swh-admin' AND rolcanlogin = true"
*******************************************
+ Postgresql_psql[ALTER ROLE "swh-admin" NOCREATEDB] =>
parameters =>
"connect_settings": {}
"cwd": "/tmp"
"db": "postgres"
"port": 5433
"psql_group": "postgres"
"psql_path": "/usr/bin/psql"
"psql_user": "postgres"
"unless": "SELECT 1 FROM pg_roles WHERE rolname = 'swh-admin' AND rolcreatedb = false"
*******************************************
+ Postgresql_psql[ALTER ROLE "swh-admin" NOCREATEROLE] =>
parameters =>
"connect_settings": {}
"cwd": "/tmp"
"db": "postgres"
"port": 5433
"psql_group": "postgres"
"psql_path": "/usr/bin/psql"
"psql_user": "postgres"
"unless": "SELECT 1 FROM pg_roles WHERE rolname = 'swh-admin' AND rolcreaterole = false"
*******************************************
+ Postgresql_psql[ALTER ROLE "swh-admin" NOREPLICATION] =>
parameters =>
"connect_settings": {}
"cwd": "/tmp"
"db": "postgres"
"port": 5433
"psql_group": "postgres"
"psql_path": "/usr/bin/psql"
"psql_user": "postgres"
"unless": "SELECT 1 FROM pg_roles WHERE rolname = 'swh-admin' AND rolreplication = false"
*******************************************
+ Postgresql_psql[ALTER ROLE "swh-admin" SUPERUSER] =>
parameters =>
"connect_settings": {}
"cwd": "/tmp"
"db": "postgres"
"port": 5433
"psql_group": "postgres"
"psql_path": "/usr/bin/psql"
"psql_user": "postgres"
"unless": "SELECT 1 FROM pg_roles WHERE rolname = 'swh-admin' AND rolsuper = true"
*******************************************
+ Postgresql_psql[ALTER ROLE swh-admin ENCRYPTED PASSWORD ****] =>
parameters =>
"command": "ALTER ROLE \"swh-admin\" ENCRYPTED PASSWORD '$NEWPGPASSWD'"
"connect_settings": {}
"cwd": "/tmp"
"db": "postgres"
"environment": "NEWPGPASSWD=md5a1ef5366acf215ee76295ac28aa629f7"
"port": 5433
"psql_group": "postgres"
"psql_path": "/usr/bin/psql"
"psql_user": "postgres"
"unless": "SELECT 1 FROM pg_shadow WHERE usename = 'swh-admin' AND passwd = 'md5a1ef5366acf215ee76295ac28aa629f7'"
*******************************************
+ Postgresql_psql[CREATE ROLE swh-admin ENCRYPTED PASSWORD ****] =>
parameters =>
"command": "CREATE ROLE \"swh-admin\" ENCRYPTED PASSWORD '$NEWPGPASSWD' LOGIN NOCREATEROLE NOCREATEDB SUPERUSER CONNECTION LIMIT -1"
"connect_settings": {}
"cwd": "/tmp"
"db": "postgres"
"environment": "NEWPGPASSWD=md5a1ef5366acf215ee76295ac28aa629f7"
"port": 5433
"psql_group": "postgres"
"psql_path": "/usr/bin/psql"
"psql_user": "postgres"
"unless": "SELECT 1 FROM pg_roles WHERE rolname = 'swh-admin'"
*******************************************
*** End octocatalog-diff on db0.internal.staging.swh.network
```