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

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.

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

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.

Does this user/password have the CREAT privilege in Postgres? What happens if you use

    rake db:test:create

from inside your project folder?

I am getting error

rake aborted!

Don’t know how to build task ‘db:test:create’

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.

Does this user/password have the CREAT privilege in Postgres? What happens if you use

    rake db:test:create

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