Search Engine: Elastic

Article ID: 131252, created on Aug 6, 2017, last review on Aug 6, 2017

  • Applies to:
  • Business Automation 7.1

Symptoms

OA database node and PostgreSQL server have different time zones what leads to wrong time in SQL statements performed through PostgreSQL console.

Cause

Incorrect time zone is set in PostgreSQL configuration file. Current time zone settings can be checked by running the following command on billing database server:

# grep timezone /var/lib/pgsql/9.6/data/postgresql.conf
log_timezone = 'US/Eastern'
timezone = 'US/Eastern'

Resolution

  1. In case of wrong zones in postgresql.conf its content can be adjusted to comfort the correct time zone. Full list of zones is available in pg_timezone_names view:

    pba=> SELECT * FROM pg_timezone_names;
    

To apply changes made to configuration file it is required to stop pba service, restart PostgreSQL service, and start pba service back.

Note

Path to postgresql.conf can be different in some cases.

7c0b495571a6c1bec50e4f324a20ec14 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 198398b282069eaf2d94a6af87dcb3ff b2c3b33425dfc50c7d41a2efaa7f84f3

Email subscription for changes to this article
Save as PDF