Hi every one How are you? after a days and searching in forums i still can not find some things that helping me to connect Rails with postgre SQL of course those are helpful but not for a stupid person like me :D So i need my friends helping me here and advice me to how can i connect this two things (ROR and Postgre Sql) I need your help so much My eyes going blind because of searching and looking at monitor. :( Please Help me. S.O.S there is some details about my system ==> => I have MS Windows Xp on my desktop => I installed ruby 1.9.1-p378 => I installed rail 2.3.5 => I installed PostgreSql 8.4 I am a newbie in ROR so please advice me step by step PLEASE. :) Thanks and Thanks and Thanks so much ----------------- Best Regards Amir -- Posted via http://www.ruby-forum.com/. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Amir Sanaii wrote:> Hi every one > How are you? > > after a days and searching in forums i still can not find some things > that helping me > to connect Rails with postgre SQL of course those are helpful but not > for a stupid person like > me :D > > So i need my friends helping me here and advice me to how can i connect > this two things (ROR and Postgre Sql) > I need your help so much > My eyes going blind because of searching and looking at monitor. :( > Please Help me. > S.O.SWell, you''d get better help if you told us what you''d already tried and what didn''t work (with error messages as applicable).> > there is some details about my system ==> > > => I have MS Windows Xp on my desktop > => I installed ruby 1.9.1-p378 > => I installed rail 2.3.5 > => I installed PostgreSql 8.4 > > I am a newbie in ROR so please advice me step by step PLEASE. :) >Have you installed any of the gems for connecting Ruby with Postgres (such as postgres or pg)? Without these gems, Ruby can''t talk to the DB.> > > Thanks and Thanks and Thanks so much > > ----------------- > > Best Regards > AmirBest, -- Marnen Laibow-Koser http://www.marnen.org marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org -- Posted via http://www.ruby-forum.com/. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
I had same problem... but i use ubuntu 9.04... i had configure my postgresql look at this blog(it''s in pt-br) http://chevitarese.wordpress.com/2009/05/18/postgresql-ubuntu-9-04/ i think the configured is same ... XD 2010/5/12 Marnen Laibow-Koser <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>> Amir Sanaii wrote: > > Hi every one > > How are you? > > > > after a days and searching in forums i still can not find some things > > that helping me > > to connect Rails with postgre SQL of course those are helpful but not > > for a stupid person like > > me :D > > > > So i need my friends helping me here and advice me to how can i connect > > this two things (ROR and Postgre Sql) > > I need your help so much > > My eyes going blind because of searching and looking at monitor. :( > > Please Help me. > > S.O.S > > Well, you''d get better help if you told us what you''d already tried and > what didn''t work (with error messages as applicable). > > > > > there is some details about my system ==> > > > > => I have MS Windows Xp on my desktop > > => I installed ruby 1.9.1-p378 > > => I installed rail 2.3.5 > > => I installed PostgreSql 8.4 > > > > I am a newbie in ROR so please advice me step by step PLEASE. :) > > > > Have you installed any of the gems for connecting Ruby with Postgres > (such as postgres or pg)? Without these gems, Ruby can''t talk to the > DB. > > > > > > > Thanks and Thanks and Thanks so much > > > > ----------------- > > > > Best Regards > > Amir > > Best, > -- > Marnen Laibow-Koser > http://www.marnen.org > marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org > -- > Posted via http://www.ruby-forum.com/. > > -- > 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- Carina Brito Silva -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Please post database.yml file and any errors in development.log. It does work fine, postgres is my fav database for AR On May 12, 5:07 am, Amir Sanaii <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> Hi every one > How are you? > > after a days and searching in forums i still can not find some things > that helping me > to connect Rails with postgre SQL of course those are helpful but not > for a stupid person like > me :D > > So i need my friends helping me here and advice me to how can i connect > this two things (ROR and Postgre Sql) > I need your help so much > My eyes going blind because of searching and looking at monitor. :( > Please Help me. > S.O.S > > there is some details about my system ==> > > => I have MS Windows Xp on my desktop > => I installed ruby 1.9.1-p378 > => I installed rail 2.3.5 > => I installed PostgreSql 8.4 > > I am a newbie in ROR so please advice me step by step PLEASE. :) > > Thanks and Thanks and Thanks so much > > ----------------- > > Best Regards > Amir > -- > Posted viahttp://www.ruby-forum.com/. > > -- > 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@googlegroups.com. > For more options, visit this group athttp://groups.google.com/group/rubyonrails-talk?hl=en.-- 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@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Carina Brito wrote:> I had same problem... but i use ubuntu 9.04... i had configure my > postgresql > look at this blog(it''s in pt-br) > http://chevitarese.wordpress.com/2009/05/18/postgresql-ubuntu-9-04/ i > think > the configured is same ... XD > > 2010/5/12 Marnen Laibow-Koser <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> >Thanks to all thank you my friend Marnen Laibow-Koser I solved my problem with your advice and of course my god help :) I had problem on three things : first => my pgadmin ;i mean i didn''t set my pgAdmin''s username in database.Yml as user name second => I have two version for ruby so errors comes out one after another third => I set the wrong gem install for postgreSql -- Posted via http://www.ruby-forum.com/. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
special thanks to my friend Carina Brito for his help :) thank you man :) -- Posted via http://www.ruby-forum.com/. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
=^.^=..Your welcome.. but.. i''m a woman.. XD.. i''m not man heheh 2010/5/12 Amir Sanaii <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>> special thanks to my friend Carina Brito for his help :) > thank you man :) > -- > Posted via http://www.ruby-forum.com/. > > -- > 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- Carina Brito Silva -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
another question ? => Can we have and use different DBMS install gem on one machine ? for example : gem install sqlite-3 and gem install mysql and gem install ... and use one of them for each project i mean one project use MS SQL SERVER and another one use postgreSQL in the same time? -- Posted via http://www.ruby-forum.com/. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
I am so sorry please forgive me because my fault :( thank you my friend (I think this is better sentence) :D -- Posted via http://www.ruby-forum.com/. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On 12 May 2010 18:13, Amir Sanaii <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> another question ? => > > Can we have and use different DBMS install gem on one machine ? > for example : gem install sqlite-3 and gem install mysql and gem install > ... and use one of them for each project i mean one project use MS SQL > SERVER and another one > use postgreSQL in the same time?Yes, just put the appropriate setting in database.yml. You can even have different drivers between production and development on the same app. Colin -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
chris wrote:> Please post database.yml file and any errors in development.log. It > does work fine, postgres is my fav database for ARproduction: adapter: postgresql database: myportal username: usr password: pwd host: myhost development: adapter: sqlite3 database: db/development.sqlite timeout: 5000 charset: UTF8 test: adapter: sqlite3 database: db/test.sqlite timeout: 5000 charset: UTF8 oracle: adapter: oracle database: srv/instance username: usr password: pwd encoding: utf8 This is my database.yml. I use sqlite for test and development and postgres in production for my main db. I also need data from some tables located in oracle. Here is how you write model for table in oracle db: class Ora_client < ActiveRecord::Base establish_connection(:oracle) set_table_name "klients_table" end -- Posted via http://www.ruby-forum.com/. -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Maybe Matching Threads
- db connection issues in production but not in dev mode
- Sqlite3 busy and yet server has no load nor concurrency
- New to rails - apparently need patch to use PostgreSQL
- Packaging for Rails applications
- Working in install acts_as_commentable, On create, error: "unknown attribute: book_id"