Must use dsn to create connections on Windows

[sgtlaggy]

With either asyncpg.connect or asyncpg.create_pool, you must pass dsn, and cannot pass host/port/user/password/etc as args.
I feel this should be mentioned in the docs or amended.
My personal solution would be a system check or try/except NotImplementedError here and fall back to loop.create_connection.

[elprans]

That shouldn't be the case. There are tests, and they pass on Windows. Do you mind providing a code snippet that doesn't work for you?

My personal solution would be a system check or try/except NotImplementedError here and fall back to loop.create_connection.

The line you highlighted is the Unix socket connection, and should not be reached on Windows, if you provided the hostname correctly.

[sgtlaggy]

It appears not passing the host argument is the issue, I'll admit I didn't actually try the host arg before reporting this. Relying on it automatically resolving to 'localhost' causes it to attempt a unix connection with the default Unix paths it tries here.

[elprans]

That does seem like a bug.