Skip to main content
Question

Vertica version history

  • December 4, 2018
  • 3 replies
  • 17 views
Bernard92
Forum|alt.badge.img+2

Hi all,
is there a way (file/table) to list which version of Vertica have been installed/upgrade on a Vertica cluster ?
I mean : version 8.0.1 installed on the ..., upgrade to 8.1.1 on ..., upgrade to 9.0.0 on ...
Regards
Bernard

    3 replies

    Ben_Vandiver
    Forum|alt.badge.img
    • Ben_Vandiver
    • Participating Frequently
    • December 4, 2018
    I believe you can find this with the following:


    select distinct version from dc_startups order by 1;

    ________________________________
    From: Bernard92
    Sent: Tuesday, December 4, 2018 8:02:23 AM
    To: Ben Vandiver
    Subject: [AskVertica] Vertica version history

    Vertica Forum https://forum.vertica.com/
    Bernard92 started a new discussion: Vertica version history

    Hi all,

    is there a way (file/table) to list which version of Vertica have been installed/upgrade on a Vertica cluster ?

    I mean : version 8.0.1 installed on the ..., upgrade to 8.1.1 on ..., upgrade to 9.0.0 on ...

    Regards

    Bernard

    Reply to this email directly or follow the link below to check it out: https://forum.vertica.com/discussion/240179/vertica-version-history
    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • December 4, 2018

    Per Ben's comment...

    dbadmin=> select MIN(time) installed_time, version from dc_startups group by version order by 1;
        installed_time         |              version
-------------------------------+------------------------------------
 2018-07-04 09:02:52.317971-04 | Vertica Analytic Database v9.1.0-3
 2018-07-31 10:03:58.334921-04 | Vertica Analytic Database v9.1.0-4
 2018-08-08 13:44:08.154743-04 | Vertica Analytic Database v9.1.0-5
 2018-08-10 14:08:38.316001-04 | Vertica Analytic Database v9.1.1-0
 2018-08-30 10:30:58.602107-04 | Vertica Analytic Database v9.1.1-1
 2018-09-20 15:12:52.021227-04 | Vertica Analytic Database v9.1.1-2
 2018-10-31 08:02:26.519625-04 | Vertica Analytic Database v9.1.1-4
 2018-11-27 22:36:55.139144-05 | Vertica Analytic Database v9.2.0-0
(8 rows)
    Bernard92
    Forum|alt.badge.img+2
    • Bernard92
    • Author
    • Participating Frequently
    • December 4, 2018

    Thanks guys - that works great

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement