title: Setting Windows PATH for Postgres tools
body: <p><strong>I cannot access PostgreSQL through the command line in Windows.</strong> 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. </p>
  
  <p>When I try to create a database by using the command</p>
  
  <pre><code>$ createdb mydb
  </code></pre>
  
  <p>as explained in the <a href="http://www.postgresql.org/docs/8.3/static/tutorial-createdb.html" rel="noreferrer">PG documentation</a>, I get the message</p>
  
  <pre><code>createdb: command not found
  </code></pre>
  
  <p>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:</p>
  
  <pre><code>$ c:/postgreSQL/9.1/bin/createdb mydb
  </code></pre>
  
  <p>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.</p>
  
  <pre><code>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
  </code></pre>
  
  <p>Any information or feedback regarding how I can fix my installment would be appreciated. </p>
  
  <p><strong>My info is as below:</strong> </p>
  
  <p>I mostly followed these sources <a href="https://stackoverflow.com/questions/7086654/installing-postgres-on-windows-for-use-with-ruby-on-rails">here</a> and <a href="http://netpie.wordpress.com/2011/03/17/setting-up-rails-3-with-postgresql-on-windows/" rel="noreferrer">here</a>. I installed a 32 bit version of 9.1 because some sources suggested issues with 64 bit.</p>
  
  <pre><code>PG download version: Installer Version 9.1 Win x86-32
  Operating System: Windows 7 (64 bit)
  </code></pre>
  
  <p><strong>pg_hba.conf</strong></p>
  
  <pre><code>#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    
  </code></pre>
  
  <p><strong>postgresql.conf</strong></p>
  
  <pre><code># - Connection Settings -
  listen_addresses = '*'
  port = 5432
  max_connections = 100
  </code></pre>
  
  <p><strong>pg_ident.conf</strong></p>
  
  <pre><code># *Everything is commented out*
  </code></pre>
  
  <p><strong>Login Role Umezo</strong> <em>#from properties window in PGAdminIII</em></p>
  
  <pre><code>Properties/Role name: Umezo
  Properties/Can login: "check"
  Role privileges: all categories "check"
  </code></pre>