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 P. 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 D. 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 D. 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