Does Directus work with Postgres 18 yet?

Help
1

I’m new to all this, but saw that postgres just did a big update to 18 with a bunch of useful improvements. Can we use Directus with Postgres 18 yet? If not, do you have an idea of when we will?

5 Answers

5
2

I’m not seeing any breaking changes in the v18 release notes that make me think it would be incompatible with Directus as it stands right now. You should be able to use the regular postgres client in Directus and connect it up to a Postgres 18 database. That being said, we haven’t updated our CI yet to test against PG 18 by default, so your mileage may vary.

I tried running PostgreSQL 18 with Directus 11.12.0 and Redis 8 on a VPS running Ubuntu 24.04.3, but it failed.

 –
4

I ran into the same issue and figured out there was a change if you are using docker.

Breaking change (PostgreSQL 18+): Default VOLUME path changed to /var/lib/postgresql

Just changing the path works fine for fresh installation. However, you may need to run pg_upgrade for existing databases.

6

I am using Directus with Postgres 18 Docker and it works fine.

3

Any idea when the CI will be updated so we know Postgres 18 will work properly?

I have no exact dates, but it's a very small tweak and something we should be able to get in soon :)

 –

As it's a very small tweak, will it be in the next release? Think a lot of Postgres users would appreciate it as Postgres 18 has a lot of performance benefits.

 –
5

I’ve tried upgrading to Postgres 18 on a dev machine, including the path change but Directus wouldn’t start. Any updates on support for Postgres 18?

I have run it locally a couple of times and big issues were lack of PostGIS in public containers. Had to install the plugin for the map support on the official container. Have not checked in the last month though. Otherwise Directus runs normally on 18 :)

 –