Forum: Ruby on Rails Not able to create test database for cucumber in postgres?

Hi all,


I create  "app_test" database in postgres with my accurate owner name.
and when i fire rake db:test:prepare i am getting  error :-

NOTICE:  database "app_test" does not exist, skipping
PG::Error: ERROR:  permission denied to create database
: CREATE DATABASE "app_test" ENCODING = 'utf8'

And when i login in postgres than my database was not present.

Don' t know why this all is happeing ?

Till now i am using development database for cucumber . But i am facing
lots of problem .


Thanks

Regards
Fahim Babar Patel

On Nov 5, 2012, at 9:11 AM, Fahim Patel wrote:

> And when i login in postgres than my database was not present.
Does this user/password have the CREAT privilege in Postgres? What 
happens if you use

  rake db:test:create

from inside your project folder?

>
> Don' t know why this all is happening ?

The error seems to be clearly about permission to create a database. 
Possibly this user could populate the database if it existed. Maybe just 
create it manually as the "root" user in PG, or upgrade the permissions 
of this user.

Walter

On Monday, November 5, 2012 8:11:23 PM UTC+5:30, Walter Lee Davis wrote:
> > NOTICE:  database "app_test" does not exist, skipping
> from inside your project folder?
>


I am getting error
rake aborted!
Don't know how to build task 'db:test:create'

On Monday, November 5, 2012 8:11:23 PM UTC+5:30, Walter Lee Davis wrote:
> > NOTICE:  database "app_test" does not exist, skipping
>
> from inside your project folder?
>
problem solve
my user have no permission to create Db
 So i alter user
and it work perfectly.

Thanks

Regards
Fahim Babar Patel