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

On Fri, 6 May 2022 at 03:04, Jerry Sievers 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 'tzda

Re: Does PGDG apt repository support ARM64?

On Fri, 1 Apr 2022 at 17:00, Magnus Hagander wrote: > > On Fri, Apr 1, 2022 at 4:52 PM Daniele Varrazzo > wrote: >> >> On Fri, 1 Apr 2022 at 16:28, Magnus Hagander wrote: >> >> > Stretch also goes end of life on June 30 2022, so just a few months away. &g

Re: Does PGDG apt repository support ARM64?

On Fri, 1 Apr 2022 at 16:28, Magnus Hagander wrote: > Stretch also goes end of life on June 30 2022, so just a few months away. You > definitely shouldn't be using that. The platform is part of the Python binary packages build chain; they are purposely on the old side of the spectrum in order t

Re: Does PGDG apt repository support ARM64?

> On 3/31/22 18:22, Daniele Varrazzo wrote: > > Are arm packages available at all? If so, what is the right procedure > > to install them? On Fri, 1 Apr 2022 at 06:07, Adrian Klaver wrote: > > From here: > > https://apt.postgresql.org/pub/repos/apt/dists/ > > I

Re: Does PGDG apt repository support ARM64?

06:07, Adrian Klaver wrote: > > On 3/31/22 18:22, Daniele Varrazzo wrote: > > Hello, > > > > Psycopg binary files are built on Debian Stretch images. I have > > noticed that, on arm64 platforms, even if the pgdg apt repository is > > configured, apt-ge

Does PGDG apt repository support ARM64?

Hello, Psycopg binary files are built on Debian Stretch images. I have noticed that, on arm64 platforms, even if the pgdg apt repository is configured, apt-get will install libpq 9.6 (from the Debian repository), not the 14 available in pgdg. As a result, certain features are not available on psyc

Re: How to build psycopg2 for Windows

On Tue, 5 Oct 2021 at 00:30, Dan Davis wrote: > > Can anyone give me a solution to build psycopg2 statically on Windows? You can follow what Appveyor does, which is the CI that builds psycopg2 packages. - this is the setup https://github.com/psycopg/psycopg2/blob/master/.appveyor/packages.yml -

Re: Regarding Postgres - Insertion Time Getting Increased As Data Volume is getting increased

On Wed, 10 Feb 2021, 09:26 Rajnish Vishwakarma, < rajnish.nationfi...@gmail.com> wrote: > Hi Postgres Team, > > The below are the scenarios which we are dealing with. > > 1) There are 20 Tables - On an average each having 150 columns. > > 2) There are 20 Threads Handled by Thread Pool Executor ( h

Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it

On Sun, 24 Jan 2021 at 08:09, Hemil Ruparel wrote: > > One small note. Aside from the fact that your server is running from a > different port, psycopg2 does not support authentication without password > afaik. It has bit me twice It is more likely that you have some misunderstanding around Pos

Designing a better connection pool for psycopg3

Hello, I've been gathering a few ideas about the connection pool I would like to provide with psycopg3. I would be happy if you would like to take a look and give some feedback. https://www.psycopg.org/articles/2021/01/17/pool-design/ Thank you very much, -- Daniele

psycopg3: prepared statements

Hello, I am gathering ideas about how to implement prepared statements in psycopg3. A plan is sketched at . Feedback is welcome, thank you very much! -- Daniele

Re: How to debug authentication issues in Postgres

IIRC you need libpq at least 10 to use password encryption other than md5. Maybe your java client uses an older version, or no libpq at all and the client library misses that feature? -- Daniele On Sat, 28 Nov 2020, 16:12 Hemil Ruparel, wrote: > I am unable to connect using Java in general. An

Types adaptation in psycopg3

Hello, I wrote a description of the psycopg3 adaptation system and the main differences compared to psycopg2: available at https://www.psycopg.org/articles/2020/11/24/psycopg3-adaptation/ Initial API docs are available at https://www.psycopg.org/psycopg3/docs/adaptation.html Feedback is welcome.

psycopg3 COPY support

Hello, I have written an article describing the new COPY support available in psycopg3: it is a big improvement to what is available in psycopg2, allowing COPY from a stream of Python objects, async operations, binary copy. You can find it at https://www.psycopg.org/articles/2020/11/15/psycopg3-co

psycopg3 and adaptation choices

Hello, I am developing psycopg3 , a major release of the psycopg2 PostgreSQL driver for Python. This release finally uses the advanced query protocol and server-side parameters binding, so adaptation of Python values to PostgreSQL data types has, at times, a diff

Re: python async with psycopg2

On Fri, 17 Jul 2020 at 20:44, Rita wrote:> > curs = conn.cursor() > curs.execute("LISTEN mychan0;") > #curs.execute("LISTEN mychan1;") #fails! > wait_select(conn) Maybe you have to wait_select after each execute. This example could be helpful. https://www.psycopg.org/docs/advanc

Re: Recomended front ends?

On Sun, Aug 11, 2019 at 7:49 PM Peter J. Holzer wrote: > Django lets you use "unmanaged" tables, but it is quite noticeable that > this isn't the primary use case. It isn't, but it's the best way to use Django for database-literate people. It's enough to ignore the Django sale pitch of the datab

Re: PGAdmin4.11.1 on Ubuntu 18.04

On Thu, Aug 1, 2019 at 4:43 PM Adrian Klaver wrote: > Yeah the requirements file shows psycopg2-2.8: > https://github.com/postgres/pgadmin4/blob/master/requirements.txt > > The issue(I'm assuming) is: > > http://initd.org/psycopg/articles/2019/04/04/psycopg-28-released/ > "Added table_oid and tab