OS: Ubuntu 22.04.1
PostgreSQL Version: 13.8
TimescaleDB Version: 2.7.1
Installation Method: Docker(timescale/timescaledb-ha:pg13.7-ts-2.7.1-latest)
Setup: 3 Node of Patroni-HA - ETCD and PgPool using Docker Swarm.
I am Planning to Uprade with docker image timescale/timescaledb-ha:pg14.7-ts-2.10.1-latest.
What I Tried:
I thought this is the simple step: I stopped the container with the current version, replaced the version of image in the docker-compose yml file to reference the new version, and then started the container. When I tried running psql inside the container, I got the error:
psql: error: connection to server on socket “/var/run/postgresql/.s.PGSQL.5432” failed: No such file or directory
Is the server running locally and accepting connections on that socket?
I checked the log of the container and I found: database file incompatible with server.(screenshot attached)
I also tried taking the dump of the database and mapping it to an upgraded version of the container. But when I am taking a dump, this error occurs:
pg_dump: warning: there are circular foreign-key constraints on this table:
pg_dump: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.
pg_dump: Consider using a full dump instead of a --data-only dump to avoid this problem.
Also, this method is not feasible as if data grows larger then it will take a lot of time to complete this process.
Is there any other way of upgrading?