Hi all,
Thanks for the help. Restarting the postgres instance fixes the issue :)
Cheers!
On 18 November 2015 at 17:36, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:
Wei Shan wrote:
> 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
There are several possibilities:
- You upgraded, but forgot to restart the postmaster.
Try "pg_ctl restart -m fast" and see if it fixes the problem.
- You connect to a different PostgreSQL installation.
What are the environment variables PGHOST and PGPORT set to?
Yours,
Laurenz Albe
Regards,
Ang Wei Shan
Ang Wei Shan
