Wrong timezone in PostgreSQL

[Vladimir_Petrosov]

Describe the problem/error/question

When I use PostgreSQL I get UTC timezone, even in env. the TZ sets as ‘Europe/Moscow’. In N8N in Workflow I see +3 timezine, which is correct. Only PostgreSQL drive works with UTC TZ. The timezone on Ubuntu machine set as +3, PosgtreSQL server has this timezone as well.

What is the error message (if any)?

• n8n version: 1.61
• Database (default: SQLite): PostgreSQL
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker-Swarm
• Operating system: Ubuntu

[Vladimir_Petrosov]

The container has MSK time

root@root:~# docker exec -it 0eb6632c82c2 date
Mon Oct 7 22:51:36 MSK 2024

[ria]

Hi @Vladimir_Petrosov

Thank you for reporting this.

Which node are using and how did you discover the discrepancy? Can you share a minimal workflow and instructions on how to reproduce this?

Thank You

[Vladimir_Petrosov]

Hi!

Just use PostgreSQL node with SQL-command ‘show timezone’

[ria]

Can you check that your timezone is preserved in the postgresql.conf?
Also, which node version are you using?

[Vladimir_Petrosov]

It’s ‘Etc/UTC’ now but I’ve changed it without restart with SET timezone = ‘Europe/Moscow’ and ALTER Datebase. So it didn’t work.

The solution was - ALTER USER XXX SET timezone = ‘Europe/Moscow’;