The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Find out When Vertica was Last Updated

Jim_KnicelyJim_Knicely - Select Field - Administrator
edited March 2019 in Tips from the Team

You can check the data collector table DC_UPGRADES to see a list of when you upgraded Vertica by version!

Example:

dbadmin=> SELECT time, new_version
dbadmin->   FROM dc_upgrades
dbadmin->  LIMIT 1 OVER (PARTITION BY new_version ORDER BY time DESC);
             time             | new_version
------------------------------+-------------
2019-02-08 06:37:00.631821-05 | v9.2.0-3
2019-02-14 15:37:10.681135-05 | v9.2.0-4
2019-03-20 11:44:51.630861-04 | v9.2.0-5
2019-03-25 09:51:24.638255-04 | v9.2.0-6
(4 rows)

Helpful Link:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/Glossary/DataCollector.htm

Have fun!

Sign In or Register to comment.