pool timed out while waiting for an open connection

[alekspickle]

Bug Description

I looked into all similar issues but I still can't understand what is the issue here. Here is how I create a pool and I get the Error: pool timed out while waiting for an open connection error. Am I doing something wrong?

Minimal Reproduction

use sqlx::postgres::PgPoolOptions;
use std::env;
use tracing::{debug, info};

const DEFAULT_DB: &str = "postgres://postgres:password@localhost";

#[tokio::main]
async fn main() -> anyhow::Result<()> {
    tracing_init();

    let db_url = env::var("DATABASE_URL").unwrap_or_else(|_| DEFAULT_DB.to_string());
    debug!(db=%db_url, "Using DB url");

    let pool = PgPoolOptions::new().connect(&db_url).await?;
    }

Info

• SQLx version: 0.6.2
• SQLx features enabled: ["runtime-tokio-rustls", "postgres"]
• Database server and version: Postgres 15.2
• Operating system: ubuntu jammy
• rustc --version: 1.67

[alekspickle]

Solved: I am stupid and my postgres was running on the port other than default (in my case 5434), as soon as I specified it in url it connected. "postgres://postgres:password@localhost:5434" I hope this issue will help for others stuck with this as I was.