Subject: Re: pg_ctl pointing postgres 9.5.4 after installation of postgres 10
To: Debraj Manna <subharaj.manna@gmail.com>,
 pgsql-admin <pgsql-admin@postgresql.org>
References: 
 <CAF6DVKNbEUk44uynYUL4XU3mn_yZKKc3wTWJstS_eNb5wrkafQ@mail.gmail.com>
 <CAF6DVKPH0a-U3baTBNixKNmokQCHCAWQ4pSaCXiAL6VNuZG1RA@mail.gmail.com>
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Message-ID: <1b4ee3f8-eeee-26e5-47dc-3f76c65118c9@catalyst.net.nz>
Date: Sun, 12 Aug 2018 18:36:25 +1200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: 
 <CAF6DVKPH0a-U3baTBNixKNmokQCHCAWQ4pSaCXiAL6VNuZG1RA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

What I suspect has happened is that:

- you have 10.4 installed

- you have 9.5 *client only* (as a result of upgrade or manual removal 
of the server package)

Examine /usr/lib/postgresql/, you will probably see a 9.5 and 10 
directory (but the 9.5 one probably won't have a postgres binary).

If you set PATH to have /usr/lib/postgresql/10/bin in front of 
everything else then you will get you 10.4 binaries. However this is a 
bit of a pain - I think you can make life simpler by using 
'update-alternatives' to make postgres version 10 the default instead of 
9.5 - or remove all the 9.5 packages (*but* if removing be careful that 
you really don't have any 9.5 databases under /var/lib/postgresql/9.5 
first...otherwise you will be reaching for your backups - at this point 
I should ask you do have backups right)?

So perhaps do a bit more investigation, and report back here before 
removing anything :-)

regards

Mark

On 12/08/18 07:26, Debraj Manna wrote:
> The same question I have asked in stackoverflow and dba.stackexchange, 
> I did not get any reply there also.
>
>  1. https://dba.stackexchange.com/questions/214671/pg-ctl-still-pointing-to-9-5-4-after-upgrade-to-postgres-10
>  2. https://stackoverflow.com/questions/51802990/pg-ctl-still-pointing-to-9-5-4-after-upgrade-to-postgres-10-in-ubuntu-14
>
>
> On Sun, Aug 12, 2018 at 12:32 AM, Debraj Manna 
> <subharaj.manna@gmail.com <mailto:subharaj.manna@gmail.com>> wrote:
>
>     Hi
>
>     I have updated postgres from 9.5.4 to the latest 10.4.
>
>     But after installation I am seeing
>
>     support@platform1:/usr/bin$ ls -lah pg_ctl
>     lrwxrwxrwx 1 root root 34 Jun 13 08:59 pg_ctl ->
>     /usr/lib/postgresql/9.5/bin/pg_ctl
>
>     The issue appears similiar to the one discussed here
>     https://stackoverflow.com/a/24763074/785523
>     <https://stackoverflow.com/a/24763074/785523>.
>
>     To install postgres 10 I have followed the below steps:-
>
>     |sudo add-apt-repository "deb
>     http://apt.postgresql.org/pub/repos/apt/
>     <http://apt.postgresql.org/pub/repos/apt/> trusty-pgdg main"|
>
>     |wget --quiet -O -
>     https://www.postgresql.org/media/keys/ACCC4CF8.asc
>     <https://www.postgresql.org/media/keys/ACCC4CF8.asc> | sudo
>     apt-key add -|
>
>     |sudo apt-get update|
>
>     |sudo apt-get install postgresql-10|
>
>     Then performed the data migration using pg_upgrade and then
>     removed postgres 9.5
>
>     Now posgres -V is also failing with the below error
>
>     support@platform1:/usr/bin$ postgres -V
>     The program 'postgres' is currently not installed. You can install
>     it by typing:
>     sudo apt-get install postgres-xc
>
>     Can someone let me know what is wrong and how can I fix it?
>
>