Re: BUG #18018: Homebrew link is broken

On Tue, Jul 11, 2023 at 11:14:31AM -0700, Gurjeet Singh wrote:
> On Tue, Jul 11, 2023 at 3:29 AM PG Bug reporting form
> <noreply@postgresql.org> wrote:
>> And the link is https://formulae.brew.sh/formula/postgresql.
>>
>> However, the link is broken. Please consider changing the link. Thanks.

This link is part of the website, not the in-core docs.  It would be
simpler to mention the search command rather than each formula
individually, as that could easily rot across the years.

> Homebrew does not (no longer?) provides a formula named postgresql;
> instead, it provides a formula for each of the Postgres major
> versions. See the output of brew commands below [1].
>
> The difficulty is that, which is also pointed out in the first
> command's output, is that each major version of postgres introduces
> backwards incompatible changes, and hence a simple brew update or
> upgrade will break the user's database setup.

This is not surprising, that's the only way for distributions to do
upgrades in a predictible way.

> $ brew formulae | grep postgresql@
> postgresql@10
> postgresql@11
> postgresql@12
> postgresql@13
> postgresql@14
> postgresql@15
> postgresql@9.4
> postgresql@9.5

It's a bit surprising that they don't have a formula for 9.6, but
well, that's been EOL by the community for some time now.  I can see
that as well in my own setup.
--
Michael