Fahim Patel
2012-Nov-05 14:11 UTC
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 -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
Walter Lee Davis
2012-Nov-05 14:39 UTC
Re: Not able to create test database for cucumber in postgres?
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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > 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. > >-- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
Fahim Patel
2012-Nov-06 07:22 UTC
Re: Not able to create test database for cucumber in postgres?
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''> > > > > 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...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<javascript:>. > > > To unsubscribe from this group, send email to > rubyonrails-ta...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org <javascript:>. > > 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. > > > > > >-- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/bDkc1yZ8YNkJ. For more options, visit https://groups.google.com/groups/opt_out.
Fahim Patel
2012-Nov-06 07:40 UTC
Re: Not able to create test database for cucumber in postgres?
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. Thanks Regards Fahim Babar Patel> > > > > 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...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<javascript:>. > > > To unsubscribe from this group, send email to > rubyonrails-ta...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org <javascript:>. > > 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. > > > > > >-- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/Q83Agk-75yEJ. For more options, visit https://groups.google.com/groups/opt_out.