1

I have updated my Postgres install from 8.4 to 9.3.

Now when I log onto the server with the initial command

 sudo -u postgres psql template1

I get the following error

psql (8.4.18, server 9.3.5)
WARNING: psql version 8.4, server version 9.3.
         Some psql features might not work.
Type "help" for help.

What package do I need to install / upgrade to get psql to 9.4 version? (On red hat 6)

2

If you've installed the new server, the new clients are installed too - they're a dependency of the server.

Redhat systems now use an "alternatives" mechanism similar to Debian. You'll find that /usr/bin/psql is a symlink pointing to /etc/alternatives/pgsql-psql which is in turn a symlink to the default psql.

You can use the update-alternatives command to switch default clients - see its --help. Or you can just:

/usr/pgsql-9.3/bin/psql

directly.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.