Can we manually change the time and date from ALL Vertica Servers or will have any issue?
Article ID: 191661
Updated On:
Products
CA Infrastructure Management
CA Performance Management - Usage and Administration
DX NetOps
Issue/Introduction
Need to adjust ALL Vertica nodes Time/date
Environment
Release : 3.6
Component : IM Reporting / Admin / Configuration
Resolution
ALL Servers must have the same time to do not have a heartbeat sync issue.
Usually we change the Timezone settings at:
CAPC -> Administration -> User Settings -> Users
If you need to update all users to the same timezone you can do via mysql:
To update all the users to EST5EDT timezone run the following mysql.
mysql -unetqos -p netqosportal
mysql>update user_definitions set Timezone='EST5EDT';
mysql>\q
And finally, after change the time from ALL Servers, yes, we recommend you to Restart ALL Services from:
Data Agreggator
Data Collector
Performance Center
Data Repository
Usually we change the Timezone settings at:
CAPC -> Administration -> User Settings -> Users
If you need to update all users to the same timezone you can do via mysql:
To update all the users to EST5EDT timezone run the following mysql.
mysql -unetqos -p netqosportal
mysql>update user_definitions set Timezone='EST5EDT';
mysql>\q
And finally, after change the time from ALL Servers, yes, we recommend you to Restart ALL Services from:
Data Agreggator
Data Collector
Performance Center
Data Repository
Feedback
Yes
No
Powered by
