conf-postgres depext needs to be updated for homebrew

[haochenx]

• related: Add Petrol 1.2.3 #23909 (detailed in this comment)

Currently the package conf-postgres is specifying postgresql as the homebrew package to install on macOS (when using homebrew)

opam-repository/packages/conf-postgresql/conf-postgresql.1/opam

Line 27 in f016dc5

["postgresql"] {os = "macos" & os-distribution = "homebrew"}

But recently with homebrew, one has to explicitly specify the major version of postgres to install, e.g. brew install postgresql@14 or brew install postgresql@15 and brew install postgresql will fail.

[haochenx]

@mmottl do you have an opinion about how we should deal with this?

[mmottl]

I believe specifying a particular version may be the only reasonable choice. This is the way this problem is handled for other platforms. You may want to settle on a really stable and popular version for that.

[haochenx]

All officially released major versions of Postgres are reasonably stable and have long support periods (e.g., the current newest stable release is Postgres 15, which is released last year and will be supported until 2027).

Also, it seems that the newest Postgres 15 enjoys supports back to Big Sur on both Apple Silicon and Intel models, I think it's reasonable to default to the give the user the newest version (now Postgres 15) by default.

[haochenx]

I have opened PR #24105 to address this.