How to make Moscow time in postrgresql database in docker-compose?

Question

PostgreSQL

Hello!

version: "3.8"
services:
    db:
        image: postgres:latest
        environment:
            PGDATA: /var/lib/postgresql/data/some_name/
            POSTGRES_PASSWORD: ipadib339
            TZ: Europe/Moscow
        volumes:
            - data:/var/lib/postgresql/data
        ports:
            - "5432:5432"

Field type = timestamp without time zone TZ: Europe/Moscow does not help

I would be very grateful for the help!

Answer 1

Moscow time (or any other) for a field without a time zone is made an adjustment in the application, let it be stored in UTC in the database.