[Errno -2] Name or service not known

[2ik]

• asyncpg version: 0.18.3
• PostgreSQL version: 11
• Do you use a PostgreSQL SaaS? If so, which? Can you reproduce
  the issue with a local PostgreSQL install?:
• Python version: 3.7
• Platform: Linux Mint
• Do you use pgbouncer?: No
• Did you install asyncpg with pip?: Yes
• If you built asyncpg locally, which version of Cython did you use?:
• Can the issue be reproduced under both asyncio and
  uvloop?:

There was a similar question #467

I found a problem when connecting a pool with dsn transfer.

if the @ symbol is present in the password, then an error appears: [Errno -2] Name or service not known
if replaced by %40 then an access error password authentication failed for user "user_db"

Will give an example better:

# error:
dsn = 'postgresql://{user}:{pwd}@{host}:{port}/{database}'.format(
 host=config.DB_HOST,
 port=config.DB_PORT,
 user=config.DB_USER,
 pwd=config.DB_PASS, # passw@123
 database=config.DB_NAME
)

conn = await asyncpg.create_pool(dsn)

# successfully
conn = await asyncpg.create_pool(
 host=config.DB_HOST,
 port=config.DB_PORT,
 database=config.DB_NAME,
 user=config.DB_USER,
 password=config.DB_PASS # passw@123
)