Connecting to fly.io database proxy

[felipesere]

👋 I have weird issue!

I have my app deployed through Docker on fly.io. There, I can see that it can connect to the DB and has successfully migrated it to the latest schema.

Now I want to write a couple of tasks to do some admin duties. For this, I run the fly proxy fly proxy 5555:5432 -a $name-db-app in one tab and then run my task with the DATABASE_URL overwritten:
DATABASE_URL=postgres://$user:$password@localhost:5555/my_db cargo loco task create_user ....
But I get this error:

Error: Connection Error: pool timed out while waiting for an open connection

Caused by:
   0: pool timed out while waiting for an open connection
   1: pool timed out while waiting for an open connection

I can connect using the exact same DATABASE_URL using psql. pgcli on the other hand fails...

I struggle to find the connection (pun intended!)

[felipesere]

To make matters weird, I can get pgcli to work if I just transpose the parameters from the DATABASE_URL...

[felipesere]

I've smashed and re-created the DB but still have the exact same problem.

[felipesere]

Turns out I need to set an aquire_timeout on the DatabaseOptions to be able to connect through the fly.io proxy.
I'll raise a PR shortly to allow that option.

[felipesere]

PR: #546