Mac 安装psycopg2出错：Error:pg_config executable not found的解决

在mac 上执行pip3 install psycopg2-binary出现如下错误：

Error:pg_config executable not found

然后我又到终端里执行

brew install  postgresql@16 

显示

Warning: You are using macOS 15.
We do not provide support for this pre-release version.
It is expected behaviour that some formulae will fail to build in this pre-release version.
It is expected behaviour that Homebrew will be buggy and slow.
Do not create any issues about this on Homebrew's GitHub repositories.
Do not create any issues even if you think this message is unrelated.
Any opened issues will be immediately closed without response.
Do not ask for help from Homebrew or its maintainers on social media.
You may ask for help in Homebrew's discussions but are unlikely to receive a response.
Try to figure out the problem yourself and submit a fix as a pull request.
We will review it but may or may not accept it.

以为是安装的psycopg2 版本问题，试了安装15、16都出现以上警告。

解决办法：

1、更新brew版本

brew update

2、然后再安装postgresql@16

brew install postgresql@16

postgresql安装成功

3、添加路径

vim ~/.bash_profile

export PATH="/opt/homebrew/opt/postgresql@16/bin:$PATH"
export LDFLAGS="-L/opt/homebrew/opt/postgresql@16/lib"
export CPPFLAGS="-I/opt/homebrew/opt/postgresql@16/include"

保存后退出，
再执行

source ~/.bash_profile

4、安装psycopg2-binary

到IDE中，执行

pip3 install psycopg2-binary

完美安装成功！