Redhat – Which package to upgrade psql client

postgresqlpsqlredhat

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)

Best Answer

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.

Related Solutions

Debian – Can’t get PostgreSQL to run in Debian Lenny

I found this bug, it is solved from version 95, but you are installing the stable version(94).

Ubuntu – Multiple instances of Postgres after Ubuntu upgrade

Ubuntu being a Debian-based system has the ability to run multiple instances of Postgres as you are seeing. Generally unless configured otherwise the first instance started will have the default Postgres port and each subsequent instance will take the next higher port if it is available. These ports can be defined in the config files under /etc/postgresql/<version>/<cluster>/ so that they don't change should you need to but I'd actually need to. In fact a cursory look at the /etc/init.d/postgresql would also show you that you can set environment variables through /etc/postgresql/<version>/<cluster>/environment.

The package managers were even nice enough to include /usr/share/doc/postgresql-common/README.Debian.gz which has a section that quickly explains how the cluster management is handled including the pg_lsclusters command which will give you the Postgres version and port number along with other nice details about each configured cluster.

To answer question in comment regarding stopping an instance... You can edit the start.conf file under /etc/postgresql/<version>/<cluster>/ and change it from auto to disabled or manual. To quote the default start.conf file itself...

# Automatic startup configuration
# auto: automatically start/stop the cluster in the init script
# manual: do not start/stop in init scripts, but allow manual startup with
#         pg_ctlcluster
# disabled: do not allow manual startup with pg_ctlcluster (this can be easily
#           circumvented and is only meant to be a small protection for
#           accidents).

Best Answer

Related Solutions

Debian – Can’t get PostgreSQL to run in Debian Lenny

Ubuntu – Multiple instances of Postgres after Ubuntu upgrade

Related Topic