Re: Switching from 9.1 to 9.5 on Ubuntu 16.04

Mike,

Is the issue resolved ?

If not in case, are the following covered?

And if could you provide me on the below info?

1) Is the backup for the required database taken from the instance 9.1 and
stored in the same server?

2) If yes then stop 9.1 server and make sure only postgres 9.5 is in active
state(you can do this as "su postgres" user)

3) Ensure the active listening postgres ports on the server by:
netstat -alp | grep "5432"

4) Later as same "su postgres user" provide the connection string like
below:
/usr/lib/postgresql/9.5/bin/psql -d postgres -U miked -p
5432

5) Now issue select version()(It should be Postgres 9.5)

6) If Postgres 9.5 issue create database dbname

7) Restore the taken backup into the newly created database.

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-novice-f2132464.html