We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


vbr backup timestamp — Vertica Forum

vbr backup timestamp

mpompo Vertica Customer

Hi,
I run vbr (from crontab) at midnight to backup database.
Overything is ok, but timestamp in filename shows moment two hours earlier:
drwxr-xr-x 3 dbadmin verticadba 4096 Aug 27 00:02 backup_snapshot_20200826_220121
drwxr-xr-x 3 dbadmin verticadba 4096 Aug 28 00:02 backup_snapshot_20200827_220133

In sql is also fine:
dbadmin=> SELECT backup_timestamp FROM v_monitor.database_backups order by backup_timestamp desc;

backup_timestamp

2020-08-28 00:03:16.80799+02
2020-08-27 00:03:02.712029+02

It looks like timestamp is from UTC and everything else works in UTC+2. Is it normal?
-bash-4.1$ id
uid=44787(dbadmin) gid=31002(verticadba)
-bash-4.1$ env|grep TZ
TZ=Europe/Paris

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file