Re: pg_ctl pointing postgres 9.5.4 after installation of postgres 10

Can you explain this a bit more? You meant to say I should add postgres
binary location in PATH variable after installation?

On Sun 12 Aug, 2018, 9:15 AM Rajni Baliyan, <saan654(at)gmail(dot)com> wrote:

> 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
>