I've just finished an upgrade on an Ubuntu box with a dockerized Postgres container. The upgrade appears to have gone off great. But when log in to the docker container/server I get a warning message:
psql (9.3.10, server 9.5.2) WARNING: psql major version 9.3, server major version 9.5. Some psql features might not work.
How I did the upgrade was to spin up a new docker container with 9.5.2. Once the container was up I piped a pg_dumpall from the old server to the new server using
pg_dumpall -h localhost -U postgres -p 5432 | psql -h localhost -U postgres -p 5532. After the dump was complete I swapped the data dir:
mv /data/postgres/data data.old
mv /data/postgres/data9.5.2 data. These are the mapped volumes from the docker container. Then I stopped and removed the 9.3 container and started up the new 9.5 one with the right ports and docker name mapped. I was able to start the server and log in and everything appears to be working but the warning is giving me cause for concern.
Any ideas what I could do differently and how to resolve this warning? I have several other databases that I'll need to do this on.