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