Not able to create test database for cucumber in postgres?

rubyonrails-talk
1

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

2

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

3

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’

4

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