search

spantaleev / matrix-docker-ansible-deploy

🐳 Matrix (An open network for secure, decentralized communication) server setup using Ansible and Docker
GNU Affero General Public License v3.0
4.92k stars 1.05k forks source link

Upgrading PostgreSQL hangs at db dump #1917

Open dev-da77 opened 2 years ago

dev-da77 commented 2 years ago

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:

altsalt commented 11 months ago

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!