Re: Different versions between psq/postgres and the actual database

Hi all,

Thanks for the help. Restarting the postgres instance fixes the issue :)

Cheers!

On 18 November 2015 at 17:36, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> 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