Find the Version of Vertica that Created a Database: Quick Tip

Posted November 19, 2018 by Jim Knicely, Vertica Principal Solution Architect

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/latest/HTML/index.htm#Authoring/AdministratorsGuide/Diagnostics/DeterminingYourVersionOfVertica.htm

Have fun!