Page MenuHomeSoftware Heritage
Paste P1236

collation configuration discrepancy between production and staging dbs
ActivePublic

Authored by ardumont on Dec 6 2021, 5:57 PM.
production:
```
List of databases
+------------------------------------+--------------+----------+---------+---------+-----------------------+
| Name | Owner | Encoding | Collate | Ctype | Access privileges |
+------------------------------------+--------------+----------+---------+---------+-----------------------+
| keycloak | keycloak | UTF8 | C.UTF-8 | C.UTF-8 | |
| postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 | |
| sentry | sentry | UTF8 | C.UTF-8 | C.UTF-8 | |
| softwareheritage-deposit | swhstorage | UTF8 | C.UTF-8 | C.UTF-8 | |
| softwareheritage-scheduler | swhscheduler | UTF8 | C.UTF-8 | C.UTF-8 | |
| softwareheritage-scheduler-updater | swhscheduler | UTF8 | C.UTF-8 | C.UTF-8 | |
| swh-lister | swh-lister | UTF8 | C.UTF-8 | C.UTF-8 | |
| swh-vault | swh-vault | UTF8 | C.UTF-8 | C.UTF-8 | |
| swh-web | swh-web | UTF8 | C.UTF-8 | C.UTF-8 | |
| template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
| template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | postgres=CTc/postgres+|
| | | | | | =c/postgres |
| zack | zack | UTF8 | C.UTF-8 | C.UTF-8 | |
| zack-swh-sample | zack | UTF8 | C.UTF-8 | C.UTF-8 | |
+------------------------------------+--------------+----------+---------+---------+-----------------------+
(13 rows)
```
staging:
```
17:55:48 swh-scheduler@db1:5432=> \l
List of databases
+---------------+---------------+----------+------------+------------+-------------------------------------+
| Name | Owner | Encoding | Collate | Ctype | Access privileges |
+---------------+---------------+----------+------------+------------+-------------------------------------+
| postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | |
| swh | swh | UTF8 | en_US.utf8 | en_US.utf8 | =T/swh +|
| | | | | | swh=CTc/swh +|
| | | | | | guest=c/swh |
| swh-deposit | swh-deposit | UTF8 | en_US.utf8 | en_US.utf8 | =T/"swh-deposit" +|
| | | | | | "swh-deposit"=CTc/"swh-deposit" +|
| | | | | | guest=c/"swh-deposit" |
| swh-indexer | swh-indexer | UTF8 | en_US.utf8 | en_US.utf8 | =T/"swh-indexer" +|
| | | | | | "swh-indexer"=CTc/"swh-indexer" +|
| | | | | | guest=c/"swh-indexer" |
| swh-lister | swh-lister | UTF8 | en_US.utf8 | en_US.utf8 | =T/"swh-lister" +|
| | | | | | "swh-lister"=CTc/"swh-lister" +|
| | | | | | guest=c/"swh-lister" |
| swh-mirror | swh-mirror | UTF8 | en_US.utf8 | en_US.utf8 | =T/"swh-mirror" +|
| | | | | | "swh-mirror"=CTc/"swh-mirror" +|
| | | | | | guest=c/"swh-mirror" |
| swh-scheduler | swh-scheduler | UTF8 | en_US.utf8 | en_US.utf8 | =T/"swh-scheduler" +|
| | | | | | "swh-scheduler"=CTc/"swh-scheduler"+|
| | | | | | guest=c/"swh-scheduler" |
| swh-vault | swh-vault | UTF8 | en_US.utf8 | en_US.utf8 | =T/"swh-vault" +|
| | | | | | "swh-vault"=CTc/"swh-vault" +|
| | | | | | guest=c/"swh-vault" |
| swh-web | swh-web | UTF8 | en_US.utf8 | en_US.utf8 | =T/"swh-web" +|
| | | | | | "swh-web"=CTc/"swh-web" +|
| | | | | | guest=c/"swh-web" |
| template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
| template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
+---------------+---------------+----------+------------+------------+-------------------------------------+
(11 rows)
```