Product Documentation

Appearance

All platforms

override_version (string) ​

This allows the version string returned by the database to be changed to match that required by drivers or third-party applications. For example, a client may not recognize Yellowbrick as a supported database, but will function fine with PostgreSQL. Similarly, perhaps a newer version of PostgreSQL needs to be declared for compatibility.

For example:

sql
SET override_version='PostgreSQL 9.5.10 on x86_64-redhat-linux-gnu'

To set the version system-wide and commit the change:

sql
ALTER SYSTEM SET override_version='PostgreSQL 9.5.10 on x86_64-redhat-linux-gnu';
SELECT pg_reload_conf();

The version can also be overridden for just a particular role or session.