search

oban-bg / oban

💎 Robust job processing in Elixir, backed by modern PostgreSQL and SQLite3
https://getoban.pro
Apache License 2.0
3.27k stars 309 forks source link

Required postgres version for running Oban #9

Closed axelson closed 5 years ago

axelson commented 5 years ago

From the readme I can see that developing Oban requires PostgreSQL 10+, does running Oban require PostgreSQL 10+ as well or is there a lower version requirement?

sorentwo commented 5 years ago

@axelson Technically PostgreSQL 9.5+ includes FOR UPDATE SKIP LOCKED, which is the newest feature I know of. I had initially planned on using native partitioning for pruning but backed off on that.

So, if you're running 9.5+ it should work for you. Please let me know if that isn't the case!

I'll make this clear in the docs.

axelson commented 5 years ago

We're on 9.6 so that'll work for us! Thanks!

sorentwo commented 5 years ago

I've documented the minimum PG, Elixir and Erlang versions. Thanks @axelson 👍

axelson commented 5 years ago

Great, thanks!

manukall commented 4 years ago

Hey there. I noticed that the referenced commit mentions 9.6 as the minimum required PG version, while above you're talking about 9.5.

We're still stuck with 9.5 and were planning to switch to Oban. Do we need to wait until we can upgrade our Postgres servers?

sorentwo commented 4 years ago

@manukall There are a few changes since this issue that made 9.6 the minimum version. So sadly yes, you need to wait until you can upgrade PG.

manukall commented 4 years ago

@sorentwo Alright, thanks.