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.RegardsRajniOn Sun, 12 Aug 2018 at 5:27 am Debraj Manna <subharaj.manna@gmail.com> wrote:The same question I have asked in stackoverflow and dba.stackexchange, I did not get any reply there also.https://dba.stackexchange.com/questions/214671/pg-ctl-still-pointing-to-9-5-4-after-upgrade-to-postgres-10https://stackoverflow.com/questions/51802990/pg-ctl-still-pointing-to-9-5-4-after-upgrade-to-postgres-10-in-ubuntu-14On Sun, Aug 12, 2018 at 12:32 AM, Debraj Manna <subharaj.manna@gmail.com> wrote:HiI 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_ctllrwxrwxrwx 1 root root 34 Jun 13 08:59 pg_ctl -> /usr/lib/postgresql/9.5/bin/pg_ctlThe 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 updatesudo apt-get install postgresql-10Then performed the data migration using pg_upgrade and then removed postgres 9.5 Now posgres -V is also failing with the below errorsupport@platform1:/usr/bin$ postgres -VThe program 'postgres' is currently not installed. You can install it by typing:sudo apt-get install postgres-xcCan someone let me know what is wrong and how can I fix it?-- ThanksRegards,Rajni0410472086
The same question I have asked in stackoverflow and dba.stackexchange, I did not get any reply there also.https://dba.stackexchange.com/questions/214671/pg-ctl-still-pointing-to-9-5-4-after-upgrade-to-postgres-10https://stackoverflow.com/questions/51802990/pg-ctl-still-pointing-to-9-5-4-after-upgrade-to-postgres-10-in-ubuntu-14On Sun, Aug 12, 2018 at 12:32 AM, Debraj Manna <subharaj.manna@gmail.com> wrote:HiI 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_ctllrwxrwxrwx 1 root root 34 Jun 13 08:59 pg_ctl -> /usr/lib/postgresql/9.5/bin/pg_ctlThe 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 updatesudo apt-get install postgresql-10Then performed the data migration using pg_upgrade and then removed postgres 9.5 Now posgres -V is also failing with the below errorsupport@platform1:/usr/bin$ postgres -VThe program 'postgres' is currently not installed. You can install it by typing:sudo apt-get install postgres-xcCan someone let me know what is wrong and how can I fix it?
HiI 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_ctllrwxrwxrwx 1 root root 34 Jun 13 08:59 pg_ctl -> /usr/lib/postgresql/9.5/bin/pg_ctlThe 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 updatesudo apt-get install postgresql-10Then performed the data migration using pg_upgrade and then removed postgres 9.5 Now posgres -V is also failing with the below errorsupport@platform1:/usr/bin$ postgres -VThe program 'postgres' is currently not installed. You can install it by typing:sudo apt-get install postgres-xcCan someone let me know what is wrong and how can I fix it?
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
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных