Issue with connection to database with postgres (asyncpg)

[kiddten]

There is simplified example extracted from /databases/backends/postgres.py:connect()

import asyncio

import asyncpg

from databases import DatabaseURL

async def run():
    url = 'postgresql://user:password@localhost/dbname'
    pool = await asyncpg.create_pool(str(DatabaseURL(url)))


loop = asyncio.get_event_loop()
loop.run_until_complete(run())

I am getting error socket.gaierror: [Errno -3] Temporary failure in name resolution and that's fair since according to https://magicstack.github.io/asyncpg/current/api/index.html#connection-pools accepts dsn (str) – Connection arguments specified using as a single string in the following format: postgres://user:pass@host:port/database?option=value like that.

So we need to add some note to docs maybe or handle that situation via advanced parsing maybe..

[kiddten]

Whoops just read my comment again and that is exactly same format 🤣
But there is still an issue related to gaierror
Thought when I'am trying to execute await asyncpg.connect(user=, password=, etc) with kwargs thats work..

[tomchristie]

I didn't understand the issue. Could you try to rephrase it?
What do I need to do to reproduce the issue?

[kiddten]

@tomchristie I've figured out what's going on. Details MagicStack/asyncpg#436

[tomchristie]

Okay, thanks for the update.