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

Changing the default database time zone on ALL Nodes

Hi,
I studied this article:
https://forum.vertica.com/discussion/239807/changing-the-default-database-time-zone
but it changed only default time zone of one node, so I repeated it on all nodes (it means database stopped and started on each node).
Is there any better way to configure timezone altogether?

Tagged:

Answers

  • Jim_KnicelyJim_Knicely Administrator

    @verban - That post showed you how to change the DB default timezone. If you want the Linux TZ variable on each node to be the same, that's a manual process that does not involve restarting the DB. You just have to log on to each server and set it. You can easily do that in a script.

  • Jim_KnicelyJim_Knicely Administrator
    edited September 7

    @verban - If your intention is to change the database default TZ, you only need to change the Linux TZ variable on one node, then restart the DB using admintools from that node.

  • @Jim_Knicely said:
    @verban - If your intention is to change the database default TZ, you only need to change the Linux TZ variable on one node, then restart the DB using admintools from that node.

    First i set TZ on one node, but result of 'select now()' was different on other nodes (other nodes returned old timezone)
    Finally i set TZ on each nodes (on /etc/environment as globally, not locally with export that mentioned in the article) and restart the DB using admintools and it fixed on all nodes.

Leave a Comment

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

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