Re: Switching from 9.1 to 9.5 on Ubuntu 16.04 - Mailing list pgsql-novice

From pavan95
Subject Re: Switching from 9.1 to 9.5 on Ubuntu 16.04
Date
Msg-id 1534845243951-0.post@n3.nabble.com
Whole thread Raw
In response to Switching from 9.1 to 9.5 on Ubuntu 16.04  (Mike Dewhirst <miked@dewhirst.com.au>)
Responses Re: Switching from 9.1 to 9.5 on Ubuntu 16.04
List pgsql-novice
Hi Mike,

Are both Postgresql instances 9.5 and 9.1 are on same server??

>>When trying to createdb I'm getting the following error ...

What is the exact statement you have specified did you explicitly specified
any port??

My quick questions:

1) What does "sudo service postgresql status" give as root user?

2) Login as /su postgres/ and try finding the status of both 9.1 and 9.5
individually as shown below and paste the output:

/usr/lib/postgresql/9.5/bin/pg_ctl -D "/var/lib/postgresql/9.5/main" status
/usr/lib/postgresql/9.1/bin/pg_ctl -D "/var/lib/postgresql/9.1/main" status


It will help us to know which port is active postgres referring to?


Regards,
Pavan.



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


pgsql-novice by date:

Previous
From: Mike Dewhirst
Date:
Subject: Re: Switching from 9.1 to 9.5 on Ubuntu 16.04
Next
From: Mike Dewhirst
Date:
Subject: Re: Switching from 9.1 to 9.5 on Ubuntu 16.04