Re: BUG #18018: Homebrew link is broken

On Tue, Jul 11, 2023 at 3:29 AM PG Bug reporting form
<noreply(at)postgresql(dot)org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 18018
> Logged by: John Lin
> Email address: johnlinp(at)gmail(dot)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(at)10 postgresql(at)12 postgresql(at)14
postgresql(at)9(dot)4 qt-postgresql
postgresql(at)11 postgresql(at)13 postgresql(at)15
postgresql(at)9(dot)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(at)10
postgresql(at)11
postgresql(at)12
postgresql(at)13
postgresql(at)14
postgresql(at)15
postgresql(at)9(dot)4
postgresql(at)9(dot)5

+CC pgsql-www(at)postgresql(dot)org, for their visibility.

Best regards,
Gurjeet
http://Gurje.et