Rails Connect with Postgresql database in application ubuntu

Question

I am using ubuntu 12.04 and rails 3.2. I am creating a rails application in which I'm using PostgreSQL databse. I installed postgresql using the following command:

sudo apt-get install postgresql

for reference i checked out https://help.ubuntu.com/community/PostgreSQL. Later I created the user postgres and set the password postgres using the following command

sudo -u postgres psql postgres
\password postgres

Next I created the database using:

 sudo -u postgres createdb mydb

I tried to connect with Postgresql with the username postgres and password postgres and got successfully connected with the following command:

psql -U postgres -h localhost
Password for user postgres:
psql (9.1.4)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
postgres=#

In my rails app my database.yml has the following code:

development:
 adapter: postgresql
 encoding: unicode
 database: mydb_development
 pool: 5
 username: postgres
 password: postgres

test:
 adapter: postgresql
 encoding: unicode
 database: mydb_test
 pool: 5
 username: postgres
 password: postgres

production:
 adapter: postgresql
 encoding: unicode
 database: mydb_production
 pool: 5
 username: postgres
 password: postgres

Now when I run the command rake db:migrate i get the following error:

rake aborted!
FATAL:  Peer authentication failed for user "postgres"

I tried adding host: localhost to database.yml for each environment and i get the following error:

rake aborted!
couldn't parse YAML at line 28 column 0

The line 28 is

development:
 adapter: postgresql
 encoding: unicode
 database: hackathonio_development
 pool: 5
 username: postgres
 password: testing
 host: localhost {This is line 28}

Please help me figure out a solution for this..

Does adding host: localhost to the bottom of each environment fix the problem? — jake
– jake, Commented Aug 14, 2012 at 12:46
There is an answer to that in here: stackoverflow.com/questions/9987171/… — davidrac
– davidrac, Commented Aug 14, 2012 at 12:47
@dezso Can you tell me a command to check if those DB's exist. I checked out lot many links but dint get an appropriate solution. — Swati Aggarwal
– Swati Aggarwal, Commented Aug 14, 2012 at 12:55
Try this: psql -U postgres and then \c mydb_production for example. — András Váczi
– András Váczi, Commented Aug 14, 2012 at 12:58
I think there is indentation of 2 in YAML? no? odd that you should get yaml parsing error. — Aditya Sanghi
– Aditya Sanghi, Commented Aug 14, 2012 at 14:00

Community · Accepted Answer · 2017-05-23 12:14:01Z

1

I think you may have 2 problems. First, the host not being set as Shreyas pointed out. But I believe the second problem is that when you set the hostname Rails is trying to connect to PostgreSQL via a tcp socket and not a local ruby socket. My guess is you need to modify your pg_hba.conf file to allow postgres to login via localhost. Below are a few SO questions with answers that may help.

Rails can't login to postgresql - PG::Error - password - Correct info

What's the difference between "local" and "localhost" connection types in pg_hba.conf?

Can't use postgres user in new database for rails 3 on ubuntu 10.04 server

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Aug 14, 2012 at 14:28

nathan

5,7394 gold badges38 silver badges50 bronze badges

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

Comments

Shreyas Agarwal · Accepted Answer · 2012-08-14 12:46:18Z

0

Please add host to your yml as localhost

answered Aug 14, 2012 at 12:46

Shreyas Agarwal

1,1288 silver badges10 bronze badges

4 Comments

Swati Aggarwal Over a year ago

I did as you said but i again got an error. I edited my question and mentioned the error.

Shreyas Agarwal Over a year ago

Add 127.0.0.1 in your host and please remove the {} in your yaml file

Swati Aggarwal Over a year ago

{} is not present in yaml file. I jst wrote it to specify the line number.

Shreyas Agarwal Over a year ago

Then please check spaces in your YAML file. YAML is not able to read your yaml file properly I guess.

Jason Swett · Accepted Answer · 2012-08-14 13:57:41Z

My recommendation:

Step 1

Create a new, different user by running

$ createuser <username>

on the command line. You'll be prompted for password, etc. (Examples/docs: http://www.postgresql.org/docs/8.1/static/app-createuser.html)

Step 2

Update database.yml with the new users's username/password. Forget the first user you created, at least for now.

Step 2

$ rake db:create

Step 3

$ rake db:migrate

I think those steps are more likely to work that what you're trying.

Collectives™ on Stack Overflow

Rails Connect with Postgresql database in application ubuntu

3 Answers 3

Comments

4 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Linked

Related