Although psql -V command shows 14 version, but if I check psql version from within database I am getting another result:
1) sudo -u postgres psql
psql (14.5 (Ubuntu 14.5-0ubuntu0.22.04.1), server 10.22 (Ubuntu 10.22-0ubuntu0.18.04.1)) Type "help" for help.
2) SELECT version(); PostgreSQL 10.22 (Ubuntu 10.22-0ubuntu0.18.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
Can the author of this post tell us how did he upgraded psql version?
Although psql -V command shows 14 version, but if I check psql version from within database I am getting another result:
1) sudo -u postgres psql
psql (14.5 (Ubuntu 14.5-0ubuntu0. 22.04.1) , server 10.22 (Ubuntu 10.22-0ubuntu0. 18.04.1) )
Type "help" for help.
2) SELECT version(); 18.04.1) on x86_64- pc-linux- gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~ 18.04) 7.5.0, 64-bit
PostgreSQL 10.22 (Ubuntu 10.22-0ubuntu0.
Can the author of this post tell us how did he upgraded psql version?