Postgres data migration

Quick note how to upgrade a postgresql from version 9.3 to 9.5. You’ll need to start both services. In my case postgresql 9.3 was listen on port 5432 (defaul port) and postgresql on port 5433.

Now you need to run:

pg_dumpall |psql -d postgres -p 5433

Depending on the size of your dbs it will take some time. When this went well you can connect to the postgresql-9.5 to check that the databases are correctly migrated. Next is to stop postgresql-9.3 and reconfigure postgresql-9.5 to listen on the default port. Restart postgres-9.5 and here we go!

best regards akendo