Find out When Vertica was Last Updated
Jim_Knicely
- Select Field - Administrator
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!
0