Not able to create test database for cucumber in postgres?

[Fahim 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. 

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

[Walter Lee Davis]

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

> 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

>
> Till now i am using development database for cucumber . But i am facing lots of problem .
>
>
> Thanks
>
> Regards
> Fahim Babar Patel
>

> --
> 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 rubyonra...@googlegroups.com.
> To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/bcQRQcM4BBQJ.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

[Fahim Patel]

On Monday, November 5, 2012 8:11:23 PM UTC+5:30, Walter Lee Davis wrote:

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

> 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'

[Fahim Patel]

On Monday, November 5, 2012 8:11:23 PM UTC+5:30, Walter Lee Davis wrote:

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

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