Redshift support after postgresql@14 deprecation

[ramananayak]

As I know when we setup pgcli from brew. It install postgresql@14. and this is the last version where Amazon Redshift has supported.
Amazon Redshift deviated Postgres library after this. So Redshift is not supported if we upgrade the library to something after this.
Now I see below message

Warning: postgresql@14 has been deprecated because it is not supported upstream! It will be disabled on 2026-11-12.

So is there any plans for alternatives for this to support Redshift on pgcli ?

[j-bennet]

pgcli itself does not require or enforce a specific version of postgresql. If you look at pyproject.toml where our dependencies are listed, you'll see nothing about postgresql.

We're not supporting the pgcli formula, the Homebrew maintainers do. However, I'm surprised that pgcli would install postgresql. In the latest formula, I only see dependency on python and libpq.

https://github.com/Homebrew/homebrew-core/blob/a3719cce5f3981bbd9ae73fa9548727c25eeb664/Formula/p/pgcli.rb#L19-L20

We already had to deal with a similar problem a long time ago (some history in #718), and back then it was solved by vendoring in libpq. It could be that something has changed in libpq.

Why not use pip to install pgcli? That way, you'd also have the benefit of getting the latest version sooner.

[ramananayak]

sure. thanks. let me try this. and see if this solves the problem for Redshift.