[pgpool-general: 7438] Re: Supported python async drivers

[Tatsuo Ishii]

> Hi,
> 
> I am using pgpool2 for failover (and maybe later load balancing, it's a
> long story...) and am starting to migrate some of my code to use async.
> Many async projects that support postgres I have seen do so via asyncpg.
> asyncpg doesn't seem to work at all with pgpool2 (at least with my current
> pgpool config, which works perfectly synchronously with psycopg2). Basic
> initial testing suggests aiopg does support pgpool2, at least for what I
> tested it with. This is probably because it is based on psycopg2-binary.
> 
> Unfortunately almost all of the projects I have been looking at using that
> require async postgres only support asyncpg (Broadcaster, TortoiseORM,...),
> not aiopg.
> 
> Is there an officially supported async driver for python? Is one planned?

I am not familiar with "async" nor "asyncpg". To understand what they
are doing, it would be helpful to config Pgpool-II with
log_client_messages = on and share the pgpool log.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp