How do I put PostgreSQL /bin directory on my path in Windows?

Question

I've got a fairly simple question I guess. I'm working on a Ruby on Rails app. I'm trying to switch to PostgreSQL thanks to Heroku.

In my database.yml file it states:

  Install PostgreSQL and put its /bin directory on your path.

My question is how do I put PostgreSQL's /bin directory on my path? Exactly which file do I modify and how?

I imagine this is my issue since when I run the "rails db" command i get:

"Couldn't find database client: psql,psql.exe. Check your $PATH and try again."

Thanks everyone! Robin.

Are you on Windows, Mac or Linux? The system is telling you to alter an environment variable (called "PATH") which is a setting that is stored on your local computer. There are several ways this can be done, depending on your operating system you use... so if you can tell us, we can then help you. — Taryn East, Sep 06 '12 at 04:04

score 4 · Answer 1 · edited Sep 06 '12 at 00:53

4

Append the directory to system PATH (not user PATH) by Environment Variables, using a semicolon to separate it from the previous entry.

You can find it from control pannel -> system -> Advanced -> Environment Variables

edited Sep 06 '12 at 00:53

Craig Ringer

307,061
76
688
778

answered Sep 05 '12 at 11:09

Hans Chen

191
6

Why not the user path? IMO it's much safer to modify the user path. – Craig Ringer Sep 06 '12 at 00:54
Hi Craig, I just pointed the easiest way. I thought he will have question again to run it as service if choosing user path. – Hans Chen Sep 06 '12 at 07:43

score 1 · Answer 2 · answered Oct 12 '12 at 06:11

Ran into the same issue and tried the solution mentioned here

[user@host user]$ 
psql

bash: psql: command not found
[user@host user]$ 
echo $PATH

/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin
[user@host user]$ 
export PATH=$PATH:/usr/local/pgsql/bin

[user@host user]$ 
psql testdb

Should do the trick.

score 0 · Answer 3 · answered Sep 05 '12 at 11:07

0

You need to install Postgres first then add the path to system properties > environment variables > in system variables section you will see PATH variable

answered Sep 05 '12 at 11:07

Rubyman

874
6
15

Kevin · Answer 4 · 2016-04-18T04:46:41.580

This is my preferred way of adding a new location to the PATH environment variable (on modern Red-Hat-based systems):

echo 'export PATH="/usr/pgsql-9.3/bin:$PATH"' | sudo tee /etc/profile.d/pgsql.sh

PATH is a colon : separated list of directories that are search, in order, for a called program.
Profile configurations under /etc are persistent for all users (but require the active shell to source them to take effect).
The version number is tacked on to the PostgreSQL directory when it is installed from their repository.

How do I put PostgreSQL /bin directory on my path in Windows?

4 Answers4

Linked