Re: pg_ctl pointing postgres 9.5.4 after installation of postgres 10

Have you set the correct environment variables after upgrade?
Your environment variables are still pointing to older version.
Set PATH to PG 10 binaries and then retry.

Regards
Rajni

On Sun, 12 Aug 2018 at 5:27 am Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
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(dot)manna(at)gmail(dot)com>
> wrote:
>
>> Hi
>>
>> I have updated postgres from 9.5.4 to the latest 10.4.
>>
>> But after installation I am seeing
>>
>> support(at)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.
>>
>> To install postgres 10 I have followed the below steps:-
>>
>> sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main"
>>
>> wget --quiet -O - 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(at)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?
>>
>
> --
Thanks
Regards,
Rajni
0410472086