Ruby on Rails

On Jan 31, 2012, at 11:59 PM, Ajit Teli wrote:

> I am able to create databases (development, test, and production
> databases) as follows
> .................................................................
> ajit@ajit:~$ su - postgres
> Password:
> postgres@ajit:~$ psql
> postgres=# create DATABASE book_shelf_development;
> CREATE DATABASE
> postgres=# create DATABASE book_shelf_test;
> CREATE DATABASE
> postgres=# create DATABASE book_shelf_production;
> CREATE DATABASE
> postgres=#
>
> ................................................................
>
> But when I try to create same databases using the command
> 'rake db:create:all', I am getting an error massage saying 'FATAL:
> Ident authentication failed for user "postgres"'. And none of the
> databases are created.
>
> And also after creating databases as shown above, I created migration
> files and I am able to do rake db:migrate for the same database.yml
> file.
>
>
> Can you please help me why 'rake db:create:all' is not working?
----
not a rails issue but an issue from not understanding postgresql.

probably a bad idea to use 'postgres' as the user/owner of a database and postgres has users/roles/grants functionality for the purpose of program interface with the postgres server.

if you are intent on using postgres without gaining any knowledge about it's authentication mechanisms, then you should understand that user postgres doesn't have a password and out of the box, can only use the localhost postgresql server via a local socket (not TCP/IP) - thus database.yml shouldn't have a password, a port # or anything but the actual local socket (/var/run/postgresql/$SOME_PID_FILE ?)

Craig

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.