Re: Switching from 9.1 to 9.5 on Ubuntu 16.04

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Switching from 9.1 to 9.5 on Ubuntu 16.04
Date: 2018-08-21 09:54:03
Message-ID: 1534845243951-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mike Dewhirst 2018-08-21 11:01:17 Re: Switching from 9.1 to 9.5 on Ubuntu 16.04
Previous Message Mike Dewhirst 2018-08-21 07:41:51 Re: Switching from 9.1 to 9.5 on Ubuntu 16.04