Update PostgreSQL working in Docker from version 17 to version 18.
|
1 2 3 |
sudo docker compose exec postgres pg_dumpall -U postgres > backup17.sql // Edit docker compose / change data dir to empty sudo docker compose exec -T postgres sh -c "psql -U postgres" < backup17.sql |
Important: Postgres 18 changed data dir mount point:
|
1 2 |
- /mnt/docker-data/postgres17-data:/var/lib/postgresql/data - /mnt/docker-data/postgres18-data:/var/lib/postgresql |
