How to find pg config path

Question

Complete newbie here  trying to set up Django to work with PostgreSQL   I m using mac osx 10 6 8   I have also installed PostgreSQL 9 3  When I run pip install psycopg2 in terminal I get the following error  Downloading unpacking psycopg2   Downloading psycopg2-2 5 2 tar gz  685kB   685kB downloaded   Running setup py  path  private var folders A9 A99cs6x0FNusPejCVkYNTE   TI -Tmp- pip build bengorman psycopg2 setup py  egg info for package psycopg2      Error  pg config executable not found       Please add the directory containing pg config to the PATH     or specify the full executable path with the option           python setup py build ext --pg-config  path to pg config build          or with the pg config option in  setup cfg       Complete output from command python setup py egg info      running egg info  creating pip-egg-info psycopg2 egg-info  writing pip-egg-info psycopg2 egg-info PKG-INFO  writing top-level names to pip-egg-info psycopg2 egg-info top level txt  writing dependency links to pip-egg-info psycopg2 egg-info dependency links txt  writing manifest file  pip-egg-info psycopg2 egg-info SOURCES txt   warning  manifest maker  standard file  -c  not found    Error  pg config executable not found     Please add the directory containing pg config to the PATH  or specify the full executable path with the option         python setup py build ext --pg-config  path to pg config build        or with the pg config option in  setup cfg     I ve seen a number of posts on this  how-to-install-psycopg2-with-pip-on-python  pg-config-executable-not-found   but I have no clue how to find the bin folder location containing pg config   Any tips on finding this path

User · Answer

This is how to simply get the path of pg config    which pg config                    prints the directory location   usr bin pg config

User · Answer

Postgres app was updated recently  Now it stores all the binaries in  Versions  folder  PATH   Applications Postgres app Contents Versions 9 4 bin  PATH    Where 9 4      version of PostgreSQL

User · Answer

I recommend that you try to use Postgres app   http   postgresapp com  This way you can easily turn Postgres on and off on your Mac   Once you do  add the path to Postgres to your  profile file by appending the following   PATH   Applications Postgres app Contents Versions latest bin  PATH    Only after you added Postgres to your path you can try to install psycopg2 either within a virtual environment  using pip  or into your global site packages

User · Answer

You can find the pg config directory using its namesake     pg config --bindir  usr lib postgresql 9 1 bin      Tested on Mac and Debian   The only wrinkle is that I can t see how to find the bindir for different versions of postgres installed on the same machine   It s fairly easy to guess though   -   Note  I updated my pg config to 9 5 on Debian with   sudo apt-get install postgresql-server-dev-9 5

User · Answer

check  Library PostgreSQL 9 3 bin and you should find pg config  I E   Library PostgreSQL  lt version num gt    ps  you can do the following if you deem it necessary for your pg needs -  create a  profile in your   directory  export PG HOME  Library PostgreSQL 9 3 export PATH  PATH  PG HOME bin   You can now use psql or postgres commands from the terminal  and install psycopg2 or any other dependency without issues  plus you can always just ls  PG HOME bin when you feel like peeking at your pg dir

User · Answer

I used    export PATH  PATH  Library PostgreSQL 9 6 bin  pip install psycopg2

User · Answer

Works for me by installing the first the following pip packages  libpq-dev and postgresql-common

User · Answer

To summarize -- PostgreSQL installs its files  including its binary or executable files  in different locations  depending on the version number and the installation method    Some of the possibilities    usr local bin   Library PostgreSQL 9 2 bin   Applications Postgres93 app Contents MacOS bin   Applications Postgres app Contents Versions 9 3 bin    No wonder people get confused   Also  if your  PATH environment variable includes a path to the directory that includes an executable file  to confirm this  use echo  PATH on the command line  then you can run which pg config  which psql  etc  to find out where the file is located

User · Answer

Once you install the current PostgreSQL app on the MacOS X 10 11  this is where the pg config file is  Library PostgreSQL 9 5 bin pg config   Then on the Terminal         export PG HOME  Library PostgreSQL 9 5       export PATH  PATH  PG HOME bin   This will put the path in the  profile of whatever terminal you are using   In your environment  assuming you are using virtualenv  you then install psycopg2         pip install psycopg2   You should see if you had downloaded it before       Collecting psycopg2       Using cached psycopg2-2 6 1 tar gz     Installing collected packages  psycopg2       Running setup py install for psycopg2     done     Successfully installed psycopg2-2 6 1

User · Answer

Have same issue on mac  you probably need to      brew install postgresql   then you can run      pip install psycopg2   The brew will fix PATH issue for you  this solution works for me at least

User · Answer

I had exactly the same error  but I installed postgreSQL through brew and re-run the original command and it worked perfectly        brew install postgresql

User · Answer

sudo find   -name  pg config  -print   The answer is  Library PostgreSQL 9 1 bin pg config in my configuration  MAC Maverick

User · Answer

path of pg config in my case  MacOS   Library PostgreSQL 13 bin Execute the following in the terminal  PATH  quot  Library PostgreSQL 13 bin  PATH quot   Then pip install psycopg2

User · Answer

Installing homebrew   usr bin ruby -e    curl -fsSL https   raw github com gist 323731     And then installing postgresql  brew install postgresql   gave me this lovely bit of output   checking for pg config    yes   ahhh yeahhhhh

[python] How to find pg_config path

This is how to simply get the path of `pg_config`

Examples related to python

Examples related to django

Examples related to macos

Examples related to postgresql