How can i change the logs timestamp and date format when using docker?

[sti-p-sdsingh]

Hey, i am little confused regarding the timestamp and date format displayed in PostgREST's logs. I have understood that they depend on the server's timezone, but can i know, how i can change them if i am using the official docker image? I have tried changing the database's timezone but that didnt change anything.

[wolfgangwalther]

The "server" is not the "database" in this case, but the PostgREST server. You'll need to run PostgREST itself with that different timezone.

That means you need to set the environment variable TZ accordingly when running PostgREST, for example via docker.

[sti-p-sdsingh]

Thank you so much for your prompt response, @wolfgangwalther!
I tried running the container with env variable tz set to the following, but it didnt work.
Am i doing something wrong?

postgrest:
    image: postgrest/postgrest
    restart: always
    ports:
      - 3002:3000
    environment:
      PGRST_DB_URI: ****
      PGRST_DB_SCHEMA: ****
      PGRST_DB_ANON_ROLE: ****
      PGRST_JWT_SECRET: ****
      PGRST_CORS_DOMAIN: "*"  
      TZ: America/New_York
    networks:
      - backend

[wolfgangwalther]

Hm, I only tried locally, not in docker. It might be that the single-binary docker image doesn't support this - because there is no timezone data installed in the image. So you might need to create your own docker image for that. Derive from e.g. alpine and then copy the binary over from the postgrest image.

[sti-p-sdsingh]

Got it! Thanks a lot. Also, is there a way to change date format in the logs? ex. currently it is 02/Dec/2024, i want to change it to 2024/12/02.

[wolfgangwalther]

I haven't tried, but I assume that will depend on your LC_ALL / LC_TIME settings.