Setting Windows PATH for Postgres tools

Question

I cannot access PostgreSQL through the command line in Windows  Although I am able to create and update the databases  access them through PGAdminIII  and push to Heroku  I am unable to access them directly through my command line using the psql command    When I try to create a database by using the command    createdb mydb   as explained in the PG documentation  I get the message  createdb  command not found   The documentation suggests that in this case   PostgreSQL was not installed properly  Try calling the command with an absolute path instead   Sure enough  I am able to create a database by entering the direct path to the file     c  postgreSQL 9 1 bin createdb mydb   Does this mean that the path can be reconfigured to connect correctly  Or do I need to reinstall  I ve reinstalled several times  and have not been able to set the correct path  I currently have both the  bin and  lib paths addedto my system and user  Umezo  paths  but still no access from the command line   User variables for umezo variable name  Path variable value  C  PostgreSQL 9 1 bin  C  PostgreSQL 9 1 lib  System variables variable name  Path variable value  C  PostgreSQL 9 1 bin  C  PostgreSQL 9 1 lib   Any information or feedback regarding how I can fix my installment would be appreciated    My info is as below    I mostly followed these sources here and here  I installed a 32 bit version of 9 1 because some sources suggested issues with 64 bit   PG download version  Installer Version 9 1 Win x86-32 Operating System  Windows 7  64 bit    pg hba conf   TYPE     DATABASE     USER     CIER-ADDRESS     METHOD   IPv4 local connections  host      all          all      127 0 0 1 32     md5   IPv6 local connections  host      all          all        1 128          md5       postgresql conf    - Connection Settings - listen addresses       port   5432 max connections   100   pg ident conf     Everything is commented out    Login Role Umezo  from properties window in PGAdminIII  Properties Role name  Umezo Properties Can login   check  Role privileges  all categories  check

User · Answer

Settings Windows Path For Postgresql  open my Computer    gt    right click inside my computer and select properties    gt      Click on Advanced System Settings    gt         Environment Variables    gt            from the System Variables box select  PATH     gt               Edit       gt    then add this at the end of whatever you find their    C  PostgreSQL 9 2 bin  C  PostgreSQL 9 2 lib   after that continue to click OK  open cmd command prompt     open psql in command prompt with this  psql -U username database   eg  i have a database name FRIENDS and a user MEE   it will be   psql -U MEE FRIENDS   you will be then prompted to give the password of the user in question  Thanks

User · Answer

All you need to do is to change the PATH variable to include the bin directory of your PostgreSQL installation   An explanation on how to change environment variables is here    http   support microsoft com kb 310519 http   www computerhope com issues ch000549 htm  To verify that the path is set correctly  you can use   echo  PATH    on the commandline

User · Answer

Incase any one still wondering how to add environment variables then please use this link to add variables  Link   https   sqlbackupandftp com blog setting-windows-path-for-postgres-tools

User · Answer

Set path For PostgreSQL in Windows   Searching for env will show Edit environment variables for your account Select Environment Variables From the System Variables box select PATH Click New  to add new path   Change the PATH variable to include the bin directory of your PostgreSQL installation  then add new path their     for example  C  Program Files PostgreSQL 12 bin  After that click OK Open CMD Command Prompt  Type this to open psql psql -U username database name  For Example psql -U postgres test Now  you will be prompted to give Password for the User   It will be hidden as a security measure   Then you are good to go

User · Answer

In order to connect my git bash to the postgreSQL  I had to add at least 4 environment variables to the windows  Git  Node js  System 32 and postgreSQL  This is what I set as the value for the Path variable  C  Windows System32 C  Program Files Git cmd C  Program Files nodejs C  Program Files PostgreSQL 12 bin  and It works perfectly

User · Answer

configuring postreSQL PATH variable on Windows 7  I encountered this issue too  I m using Git Bash  hence the Unix-style   prompt on Windows     rails db Couldn t find database client  psql  psql exe   Check your  PATH and try again    Here s what I did   In Windows 7  navigate to   Control Panel   All Control Panel Items     System       Advanced System Settings         Environment Variables           from the System Variables box select  PATH                Edit      Then append this string to the existing PATH Variable Value    C  Program Files PostgreSQL 9 2 bin  and click  OK  three times to exit the menus   Now  close the console and restart it     Navigate back to the directory of your Rails app   In my case  this is accomplished with     cd rails projects sample app  Then  try again     rails db   sources   How do I put PostgreSQL  bin directory on my path in Windows   http   railscasts com episodes 342-migrating-to-postgresql view asciicast

User · Answer

I am using Windows 8 and the above solutions did not work out for me  I downgraded Postgres from 9 4 to 9 3  Man it worked

User · Answer

On Postgres 9 6 PgAdmin 4    this can be set up in Preferences- Paths- Binary paths   - set PostgreSQL Binary Path variable to  C  Program Files PostgreSQL 9 6 bin  or where you have installed

[windows] Setting Windows PATH for Postgres tools

Settings Windows Path For Postgresql

Examples related to windows

Examples related to path