Configuration(RelativeUrlWithoutBase) error when connecting to postgres in docker

[laurentS]

I've built a tiny api server using rocket and sqlx, with a postgres backend. This is my first rust project, so it's still very basic.

It works on my development laptop, but when deployed to my server on docker swarm, I get the following error:

thread 'main' panicked at 'Failed to connect to db with url:
"postgres://postgres:mypassword@pg:5432/app": Configuration(RelativeUrlWithoutBase)', src/main.rs:38

This is what main.rs:38 contains:

let pool = sqlx::PgPool::connect(&pg_url)
    .await
    .expect(&format!("Failed to connect to db with url: {}", pg_url).to_string());

The hostname pg is from my docker compose file, it is accessible from the container that runs sqlx (checked with ping), and the url is fine, I have other services in the same stack hitting the db with the same url.

I've seen the same error with v0.6.3 and 0.7.0-alpha.3. I've also tried removing the port number from the url, just in case, but it made no difference. On my dev laptop, the postgres url is postgres://postgres:postgres@localhost:5432/app. I can't figure out why this one works, but not the other one.

What am I missing?

[laurentS]

Just in case it helps someone else, the error was that I included double quotes in my docker-compose file around the url. So

    environment:
      # WRONG
      - DATABASE_URL="postgres://postgres:{{ dagster_postgres_password }}@pg/app"
      # RIGHT
      - DATABASE_URL=postgres://postgres:{{ dagster_postgres_password }}@pg/app

I realise this is not really a sqlx problem, sorry about the noise.

[grep-o]

Irony is that you've wrote the same thing twice :D

If you're using .env file, the correct way should be:

DATABASE_URL=postgresql://username:[email protected]:5432/postgres

[laurentS]

Indeed 🙈 I corrected my comment above. Thanks for catching the error!