Psycopg2 error: Symbol not found _PQbackendPID

I faced the same issue on macOS and solved it by running below steps:

1. Uninstall psycopg2: pip uninstall psycopg2

2. Re-install psycopg2: pip install psycopg2-binary