Re: pg_ctl pointing postgres 9.5.4 after installation of postgres 10

[Debraj Manna <subharaj.manna@xxxxxxxxx>]

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@xxxxxxxxx> 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.manna@xxxxxxxxx> 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@xxxxxxxxx> 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.

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