Which version of PostgreSQL is recommended for a new Phoenix project?

PostgreSQL just released version 10. So which version of PostgreSQL is recommended for a new Phoenix project?

1 Like

Phoenix itself has zero opinion on the underlying database. Ecto, which interfaces with postgres via Postgrex is compatible with both PostgreSQL 9 and 10, so you may as well use the newest postgres version.

2 Likes

https://github.com/elixir-ecto/postgrex supports postgres 8.4 and 9.0-9.6 according to its readme. And phoenix depends on postgrex through ecto.

EDIT: just updated to postgres 10 and everything seems to be fine.

3 Likes