Different versions between psq/postgres and the actual database

Поиск
Список
Период
Сортировка
От Wei Shan
Тема Different versions between psq/postgres and the actual database
Дата
Msg-id CAFe9ZTrNfCYHC4qwx8x3v+oioNzC2wY6X+C5WBNyvmNw_9ncCQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Different versions between psq/postgres and the actual database
Re: Different versions between psq/postgres and the actual database
Список pgsql-admin
Дерево обсуждения
Hi all,

I'm facing this issue and I wondering how to fix it.

Output of postgres --version
$ /usr/pgsql-9.2/bin/postgres --version
postgres (PostgreSQL) 9.2.14

Output of psql version
$ psql --version
psql (PostgreSQL) 9.2.14

Output of postgres DB running version.
-bash-4.1$ psql signserver
psql (9.2.14, server 9.2.4)
signserver=# select version();
                                                   version
--------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit


I'm not sure how did it got to this situation as this is the staging environment and it's monitored. Is it possible to "relink" the libraries? I prefer not to upgrade to 9.4

Thanks!
--
Regards,
Ang Wei Shan

В списке pgsql-admin по дате отправления:

Предыдущее
От: Thomas SIMON
Дата:
Сообщение: Re: Slow queries in hot standby
Следующее
От: FattahRozzaq
Дата:
Сообщение: Re: Different versions between psq/postgres and the actual database