Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: Jerry Sievers <gsievers19(at)comcast(dot)net>
Cc: pggeneral <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
Date: 2022-05-06 01:43:17
Message-ID: CA+mi_8a-4THF98vMrKPrRBYD4+2tEkDUBRA_DPM+BvAjK0nhZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 6 May 2022 at 03:04, Jerry Sievers <gsievers19(at)comcast(dot)net> wrote:
>
> Has anyone run into This?
>
> Psycopg3 fails to resolve timezone localtime on MacOS (Catalina).

That warning is typical on Windows, which doesn't have a system
timezone database, and on minimal Alpine installations, where the apk
package 'tzdata' must be installed. Never seen it reported on macOS
before.

The workaround on Windows is to install the python package tzdata
(https://pypi.org/project/tzdata/), which is a windows dependency of
psycopg.

Maybe you have a broken python package called tzdata? Your Python
installation seems mildly broken.

'localtime' is a weird timezone. However it does work on Linux for me.

-- Daniele

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2022-05-06 01:43:25 Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
Previous Message Tom Lane 2022-05-06 01:29:11 Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS