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

Posted November 19, 2018 by Jim Knicely, Big Data Solutions Architect, Vertica

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!