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

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
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:54:42
Message-ID: AE806733-8DF7-48D5-95B3-1ACB19F83CA8@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On May 5, 2022, at 8:43 PM, Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com> wrote:
>
> 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.
>
Hmmm,dunno everything else is, and has worked perfectly.

I'll try a clean venv to include tzdata and see if that helps anything.

Already did try installing tzdata and got a backtrace showoing that it was being used. Still literally says something like "FileNotFoundError, $tzdir/localtime".

As for Psycopg3 in general... Very, very nice work.

Cheers!

> '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 02:11:55 Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
Previous Message Jerry Sievers 2022-05-06 01:43:25 Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS