matrix-docker-ansible-deploy
matrix-docker-ansible-deploy copied to clipboard
spantaleev
Upgrading PostgreSQL hangs at db dump
Describe the bug
I would like to upgrade my postgres db from docker.io/postgres:13.6-alpin with the following command:
ansible-playbook -i inventory/hosts setup.yml --tags=upgrade-postgres --extra-vars="postgres_dump_dir=/tmp2" --extra-vars="postgres_dump_name=matrix-postgres-dump.sql" -K
Source: https://github.com/spantaleev/matrix-docker-ansible-deploy/blob/master/docs/maintenance-postgres.md#upgrading-postgresql
Ansible runs... but hangs on the task: matrix-postgres : Perform Postgres database dump
dump file is growing in my selected folder "/tmp2". After some minutes, i guess, dump is ready. the file is not growing anymore. BUT ansible script is not finishing the task. It sticks at "Perform Postgres database dump" for over 50 minutes.
[CTRL] + [C]
I have the latest ansible Script from # 2022-07-05 running on my computer. Connection via ssh to my matrix server.
Matrix Server:
- OS: Archlinux
- Architecture: amd64
I'm also encountering this while trying to upgrade postgres. Nothing seems to be changing in the matrix-postgres journal. Happy to hear if you found a solution or if anyone else has suggestions of debugging steps. Thanks!
