The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

The timestamp in backup snapshot

The backup snapshot name (ex:fullbackup_20200316_143005) has date and timestamp. The timestamp is picked up from where ? Is it the DB timestamp or the OS time stamp ?where to check teh same in Linux?

Answers

  • AfeAfe Employee

    Hi Sathya,
    The timestamp is obtained from the OS in UTC (Coordinated Universal Time). On Linux can obtain the timestamp format with a command like
    date -u +'%Y%m%d_%H%M%S'

  • Thanx a lot that answers my question but can it be changes to point OS timestamp ? do we need to the python script for thr same ?

  • Thanx a lot that answers my question but can it be changes to point OS timestamp ? do we need to the python script for thr same ?

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.