https://tableplus.io/blog/2018/08/postgresql-how-to-find-and-kill-hanging-query.html

#postgres #kill #slow_query #postgreSQL

One of the issues you always face with postgres on new systems is pg_config error. If you don't want to install postgres and willing to have postgres library in Pytho operational:

1. brew install libpq
2. xcode-select --install
3. echo 'export PATH="/usr/local/opt/libpq/bin:$PATH"' >> ~/.zshrc
4. env LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib" pip3 install psycopg2

#osx #libpq #pg_config #postgres #postgresql #xcode