Postgres Pro
Downloads
Home   >   mailing lists

Different versions between psq/postgres and the actual database - Mailing list pgsql-admin

From Wei Shan
Subject Different versions between psq/postgres and the actual database
Date
Msg-id CAFe9ZTrNfCYHC4qwx8x3v+oioNzC2wY6X+C5WBNyvmNw_9ncCQ@mail.gmail.com
Whole thread Raw
Responses Re: Different versions between psq/postgres and the actual database  (FattahRozzaq <ssoorruu@gmail.com>)
Re: Different versions between psq/postgres and the actual database  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Thomas SIMON
Date:
Subject: Re: Slow queries in hot standby
Next
From: FattahRozzaq
Date:
Subject: Re: Different versions between psq/postgres and the actual database