Find the Version of Vertica that Created a Database

Jim_Knicely · November 2018

You can run the VERSION() function as one method of displaying the current version of Vertica.

Example:

dbadmin=> SELECT version();
              version
------------------------------------
Vertica Analytic Database v9.1.1-4
(1 row)

But what if you want to know the version of Vertica running when you created the current database? For that info you can query the VS_GLOBAL_SETTINGS table.

dbadmin=> SELECT dbcreateversion "database_create_version"
dbadmin->   FROM vs_global_settings;
database_create_version
-------------------------
v9.1.0-3
(1 row)

Helpful Link:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Diagnostics/DeterminingYourVersionOfVertica.htm

Have fun!