pg_ctl pointing postgres 9.5.4 after installation of postgres 10

From: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pg_ctl pointing postgres 9.5.4 after installation of postgres 10
Date: 2018-08-11 19:02:57
Message-ID: CAF6DVKNbEUk44uynYUL4XU3mn_yZKKc3wTWJstS_eNb5wrkafQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Debraj Manna 2018-08-11 19:26:18 Re: pg_ctl pointing postgres 9.5.4 after installation of postgres 10
Previous Message Rui DeSousa 2018-08-11 02:34:26 Re: How to revoke privileged from PostgreSQL's superuser