Re: BUG #18018: Homebrew link is broken

On Tue, Jul 11, 2023 at 3:29 AM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      18018
> Logged by:          John Lin
> Email address:      johnlinp@gmail.com
> PostgreSQL version: Unsupported/Unknown
> Operating system:   macOS
> Description:
>
> When I went to https://www.postgresql.org/download/macosx/, there is a link
> in the sentence:
>
> > A list of PostgreSQL packages can be found using the Braumeister search
> tool.
>
> And the link is https://formulae.brew.sh/formula/postgresql.
>
> However, the link is broken. Please consider changing the link. Thanks.

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.

Unfortunately the Homebrew online formula search tool does provide a
URL for prefix-searches, else this page could've linked to the search
results, and directed the reader to pick one. Something like
https://formulae.brew.sh/formula/postgresql@

Perhaps this webpage can provide the brew command to list available
formulae, and advise to install one from the result.

[1]:
$ brew search --formulae postgresql
==> Formulae
postgresql@10           postgresql@12           postgresql@14
 postgresql@9.4          qt-postgresql
postgresql@11           postgresql@13           postgresql@15
 postgresql@9.5          postgrest

If you meant "postgresql" specifically:
postgresql breaks existing databases on upgrade without human intervention.

See a more specific version to install with:
  brew formulae | grep postgresql@

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


+CC pgsql-www@postgresql.org, for their visibility.

Best regards,
Gurjeet
http://Gurje.et