I have a Zabbix 6.4.3 stack. It uses Postgres 15.3 database.
Trying to upgrade to zabbix 7.0 and Postgres 16.3 database.
Using other Postgres guides as Zabbix documentation doesn't seem to discuss Postgres upgrade procedures.
I export db via:
docker exec -it zabbix-docker-postgres-server-1 pg_dumpall -U username > upgrade_backup_15.sql
Changed the db path in docker compose 1 folder deeper.
/home/docker/zabbix-docker/zbx_env/var/lib/postgresql/data/16.3
start zabbix 7 stack with empty db. Creates zabbix db + user/pass.
Shutdown stack.
Start only Postgres service.
cat upgrade_backup_15.sql | docker exec -i zabbix-docker-postgres-server-1 psql -d zabbix -U username
spams invalid command /n and finally stops with "out of memory"
What is different from guide I'm following is the previous command would not execute with specifying the database: -d zabbix
Obviously not doing this correctly. Any help on how to properly upgrade Zabbix database Postgres 15.3 to 16.3
Thank you.
Trying to upgrade to zabbix 7.0 and Postgres 16.3 database.
Using other Postgres guides as Zabbix documentation doesn't seem to discuss Postgres upgrade procedures.
I export db via:
docker exec -it zabbix-docker-postgres-server-1 pg_dumpall -U username > upgrade_backup_15.sql
Changed the db path in docker compose 1 folder deeper.
/home/docker/zabbix-docker/zbx_env/var/lib/postgresql/data/16.3
start zabbix 7 stack with empty db. Creates zabbix db + user/pass.
Shutdown stack.
Start only Postgres service.
cat upgrade_backup_15.sql | docker exec -i zabbix-docker-postgres-server-1 psql -d zabbix -U username
spams invalid command /n and finally stops with "out of memory"
What is different from guide I'm following is the previous command would not execute with specifying the database: -d zabbix
Obviously not doing this correctly. Any help on how to properly upgrade Zabbix database Postgres 15.3 to 16.3
Thank you.
Comment