Postgres: creating a username

Question

I'm trying to get started with Postgres on Rails apps on Mac. I made a new rails app called "shawsome" and in the database.yml file it created this

development:
adapter: postgresql
  encoding: unicode
  database: shawsome_development
  pool: 5
  username: shawsome
  password:

But the server wouldn't run because there's no role for "shawsome." Rails just seemed to have inferred the username from the name of my app.

I looked at postgres documentation and it talks about CREATE USER command

CREATE USER jonathan;

However, when I tried to do CREATE USER, it said CREATE comment not found.

Can anyone tell me what I'm doing wrong?

Also, once it's in production (on Heroku) I'm assuming it will also need a username. Will that username remain the same? i.e. if it's configured on my machine, do I need to do anything extra on Heroku?

@TheDelChop Mac 10.6.8 (not Lion), I updated the OP.

Leahcim
– Leahcim

2012-02-29 03:41:53 +00:00
Commented Feb 29, 2012 at 3:41 — Leahcim
– Leahcim, Commented Feb 29, 2012 at 3:41

Alex Marchant · Accepted Answer · 2012-02-29 04:25:09Z

3

To expand a bit on TheDelChop's answer After installation you can run the following in the terminal:

createuser -P

(The -P is to add a password)

It will ask you for name, password, whether they are a superuser, can create new roles, and can create new db's. You probably won't need any of those permissions for rails.

Then create the database to run with the following role you created:

createdb -O ROLE_NAME_FROM_PREVIOUS_STEP NEW_DATABASE_NAME

And viola, you should be good to go.

answered Feb 29, 2012 at 4:25

Alex Marchant

2,51028 silver badges49 bronze badges

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

Comments

TheDelChop · Accepted Answer · 2012-02-29 03:44:18Z

0

Then you can use the pg binary command createuser in bash/zsh. Just answer the questions they will ask you, and don't setup the database.yml for production, Heroku will take care of that.

answered Feb 29, 2012 at 3:44

TheDelChop

8,0084 gold badges50 silver badges70 bronze badges

3 Comments

Leahcim Over a year ago

but when I create the Rails app for PG, it automatically sets some settings (a database name based on the name of the app, a role that I don't really have etc) for the production database. Should I delete those? or just leave them?

Alex Marchant Over a year ago

looks like you don't need to specify production details, devcenter.heroku.com/articles/database#database_urls

Scott C Wilson Over a year ago

Yes, heroku rewrites the config/database.yml for you - see devcenter.heroku.com/articles/heroku-postgresql - @AlexMarchant link is no longer correct.

Collectives™ on Stack Overflow

Postgres: creating a username

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related