Postgres 17 support

[brianpursley]

It looks like trunk doesn't support installing extensions on Posgtres 17 yet.

Running the official postgres:17 image in Docker, I get:

root@14781ebb4965:/# trunk install pg_smtp_client

error: Currently unsupported Postgres version: PostgreSQL 17.0 (Debian 17.0-1.pgdg120+1)

[jasonmp85]

Oh hey, I didn't know there was an issue for this. This is underway (by me) and expected soon. I'll update this with progress.

[brianpursley]

@jasonmp85 Sounds good. Someone had asked for my extension (pg_smtp_client) to support pg17, which I did, but then during testing I realized trunk doesn't work with pg17 yet so I created this issue. I figured maybe someone was working on it, but didn't know for sure.

[academiaresf]

We have a similar error with pgvector:

Failed to fetch Trunk archive from v1 API: Failed to find an archive for pgvector vlatest built for PostgreSQL 17

[brianpursley]

@academiaresf It looks like pgvector was recently updated for Postgres 17, so it should work now.

@jasonmp85 I saw that trunk works with 17 now. Feel free to close this issue if it is complete.

[academiaresf]

Nice, thanks