PgCopyIn does not send any data when using read_from

[LennDG]

I have a pretty standard setup: a metrics.csv file that contains about 90MB of data and a TimescaleDB (so in reality postgres) database where I want to copy this data to.

I created a table on the DB like this:

"CREATE TABLE "metrics"(
        created timestamp with time zone default now() not null,
        type_id integer                                not null,
        value   double precision                       not null
    );"

The metrics.csv lines are formatted like:
2023-05-31 23:59:59.043264+00,13,1.78

The code I have tried to use to copy this data to the db is:

async fn load_data(pool: &Pool<Postgres>) -> Result<(), sqlx::Error> {
    let file = tokio::fs::File::open("metrics.csv").await?;
    let mut conn = pool.acquire().await?;
    let mut copy_in = conn
        .copy_in_raw("COPY metrics FROM STDIN (FORMAT CSV)")
        .await?;

    copy_in.read_from(file).await?;
    copy_in.finish().await?;
    Ok(())
}

This works fine up to the read_from call. When monitoring the network, it seems nothing is being sent, so this code just hangs forever.
Is there something else I need to do? When using the psql terminal the \COPY command works immediately.

Any help is appreciated, the COPY command would be extremely beneficial to the system I am building.

[abonander]

Are you using RusTLS?

[LennDG]

I did have that feature flag because I wanted to be agnostic of whatever TLS lib was on the host, but trying it without made it immediately work!

Is this a known issue? Or is there additional configuration I should do to make this work with RusTLS?

Thank you for the quick answer.

[abonander]

There's no open issue currently but someone else already sent a PR in that partially addresses it: #2932