Turns out there is more than just the db to drop, roles as well.
And stop the prometheus-sql-exporter and start it back when done.
So there, task!
Description
Description
Event Timeline
Comment Actions
Drop the old db:
root@belvedere:~# systemctl stop prometheus-sql-exporter.service; sudo -i -u postgres dropdb -p 5434 swh-lister; systemctl start prometheus-sql-exporter.service;
Then the role leftovers:
postgres=# drop role "lister-bitbucket"; DROP ROLE postgres=# drop role "lister-debian"; DROP ROLE postgres=# drop role "lister-github"; DROP ROLE postgres=# drop role "lister-gitlab"; DROP ROLE postgres=# drop role "lister-npm"; DROP ROLE postgres=# drop role "lister-pypi"; DROP ROLE postgres=# drop role "swh-lister"; DROP ROLE