Setting Up PostgreSQL for initial use on Mac OS

Question

I've installed PostgreSQL 9 on my local mac and it installed the "SQL Shell (psql).app" which I assume is the command shell for the server. I've opened it up but it asks for a Username [postgres]:. I type in postgres and then it asks for a password. I press enter and it gives the following error:
psql: fe_sendauth: no password supplied

How do I log in and more importantly how do I run commands like createdb? I tried the createdb command in my normal Terminal window but the command is not recognized.

Should I be using Homebrew or Macports? I haven't used either of these being new to the Mac OS

Thanks for your help!

What installation method did you use?

Daniel Lyons
– Daniel Lyons

2011-09-08 05:40:00 +00:00
Commented Sep 8, 2011 at 5:40 — Daniel Lyons
– Daniel Lyons, Commented Sep 8, 2011 at 5:40
I downloaded and installed postgresql-9.0.4-1-osx.dmg

EverTheLearner
– EverTheLearner

2011-09-08 06:21:41 +00:00
Commented Sep 8, 2011 at 6:21 — EverTheLearner
– EverTheLearner, Commented Sep 8, 2011 at 6:21

Flaviu · Accepted Answer · 2012-06-08 12:09:39Z

1

I had this problem and removing the host and port parameters from database.yml fixed it for me:

development:
  adapter: postgresql
  encoding: unicode
  database: my_db
  pool: 5
  host: localhost # remove this line
  port: 5432 # and this one

answered Jun 8, 2012 at 12:09

Flaviu

6,2944 gold badges38 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bohemian · Accepted Answer · 2011-09-08 04:55:15Z

0

If your postgres user doesn't have a password, set this env variable:

export PGPASSWORD=

answered Sep 8, 2011 at 4:55

Bohemian♦

427k103 gold badges604 silver badges750 bronze badges

1 Comment

EverTheLearner Over a year ago

where do I do this? Sorry I am new to Unix in general

Collectives™ on Stack Overflow

Setting Up PostgreSQL for initial use on Mac OS

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related