Connection pool with predefined connections

[ghuname]

Let's say that I have cluster of 6 nodes. I would like to create a connection pool with 6 connections, one per each node.

Can I implement such behavior with asynch.create_pool()?

[long2ice]

current not support

[ghuname]

In example you have provided:

async def use_pool():
    pool = await asynch.create_pool()
    async with pool.acquire() as conn:
        async with conn.cursor() as cursor:
            await cursor.execute("SELECT 1")
            ret = cursor.fetchone()
            assert ret == (1,)
    pool.close()
    await pool.wait_closed()

where connection parameters should be specified (host, port, database...)?

If I understood correctly, I should create a global pool object and afterwards, whenever I want to query database, I should use:

async with pool.acquire() as conn:
        async with conn.cursor() as cursor:
            await cursor.execute("SELECT 1")
            ret = cursor.fetchone()

Can you please confirm?

[long2ice]

params pass in create_pool, the example use default params

[ghuname]

Maybe you should update the example.