search for: postgre

Hi all I am just about to start a project using rails and am trying to setup my enviroment with postgres as the database. I have installed postgres 8.3.1 from source and am now having trouble installing the ruby- postgres gem. The following is the output trace I am getting, looks like a problem with headers/includes, any help is greatly appreciated. Thanks Simon sudo gem install ruby-postgres -- --...

People, I got rails talking to PostgreSQL 8.0 on my Mac! Once upon a time: I''m on a Mac. I want to use postqreSQL 8.0 to backend my rails. I tried a gem install... zmac11:/cd/rubythings/ruby-postgres oracle$ zmac11:/cd/rubythings/ruby-postgres oracle$ zmac11:/cd/rubythings/ruby-postgres oracle$ zmac11:/cd/rubythings/ruby-po...

Figured it out chaps..not to worry!!! -- Regards Andrew On 05/03/07, Andrew Madu <andrewmadu-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > Hi, > further to my additional email the gem build for postgres did not work, so > I downloaded and copied postgres.so into: > > C:\pgRails\lib\ruby\site_ruby\1.8\i386-msvcrt > > Again, how do I point rails to using this driver? > > -- > Regards > > Andrew > > On 05/03/07, Andrew Madu <andrewmadu-Re5JQEeQqe8AvxtiuMwx3w@pu...

I am using Puppet 3.1.0 on a CentOS 6.3 machines. The puppet master and puppet agents use CentOS 6.3 as their OS. I have a puppet script (init.pp file for the puppet module) that contains the following exec type: exec { "postgres init": cwd => "/applications/module", command => "bash initializePostgres.sh", user => "postgres", group => "postgres" } As the code alludes to, I am directing puppet to initialize a PostgreSQL database via a shell script. cwd chang...

If management server has ipv6 enabled and postgres is not configured to allow localhost access via ::1 the postgres service will fail. --- installer/modules/ovirt/manifests/postgres.pp | 8 +++++++- 1 files changed, 7 insertions(+), 1 deletions(-) diff --git a/installer/modules/ovirt/manifests/postgres.pp b/installer/modules/ovirt/manifests/...

Hi, I''m having difficulty installing the "postgres" gem. postgres-pr installed fine, but whenever I run: sudo gem install postgres I get: ERROR: While executing gem ... (RuntimeError) ERROR: Failed to build gem native extension. Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/postgres-0.7.1 for inspection. I''...

I''m at a loss to explain why the postgres gem will not work on my new server. I''ve gotten it working on several other servers in the past. The major difference between then and now is that I''m using a newer version of PostgreSQL. 8.x as opposed to 7.x. === Server setup OS: Fedora Core 6 (Commands shown with "$...

Hello people... In the rails2.pdf Dave T says: Rails works with the DB2, MySQL, Oracle, Postgres,... The database drivers are all written in C and are primarily distributed in source form. Then he lists this site: http://ruby.scripting.ca/postgres/ Then he says, There is a pure-Ruby version of the Postgres adapter available. Download postgres-pr from the Ruby-DBI page at http://rubyforge....

Me again! I have a recipe that looks like: class postgresql { file { pg_hba_conf: name => "/var/lib/pgsql/data/pg_hba.conf", source => "puppet://puppetmaster/files/workstations/common/var/lib/pgsql/data/pg_hba.conf", owner => postgres, group => postgres, mode => 600, s...

...e ldap command to wait for that service, something along the lines of: ldapsearch -b dc=priv,dc=ovirt,dc=org -x (but how will we parse the base from the installer? also this cmd fails, how to fix?) --- installer/modules/ovirt/manifests/ovirt.pp | 8 +++++- installer/modules/ovirt/manifests/postgres.pp | 13 ++++++--- ovirt-server.spec.in | 2 + scripts/ovirt-wait4service | 34 +++++++++++++++++++++++++ 4 files changed, 52 insertions(+), 5 deletions(-) create mode 100755 scripts/ovirt-wait4service diff --git a/installer/modules/ovirt/manife...

I wanted to fix some things up in the trunk, so I set up the databases and ran the unit tests. A bunch fail for postgres, and even more error out. I know of two postgresql adapters: postgres-pr and ruby-postgres. Strangely, they each fail different tests. So if I want to fix things up, which one should I be using? For that matter, which adapter should I be using for production? Finding out that the Rails unit t...

I have been struggling for hours trying to connect Rails to postgresql. I have trawled google results - all to no avail! I have installed the postgres gem but it doesn''t appear to install properly: # gem install postgres Attempting local installation of ''postgres'' Local gem file not found: postgres*.gem Attempting remote installatio...

Give this one a try which will require the user/hosts permissions to be setup prior to starting postgres --- installer/modules/ovirt/manifests/postgres.pp | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/installer/modules/ovirt/manifests/postgres.pp b/installer/modules/ovirt/manifests/postgres.pp index c46b360..381d67c 100644 --- a/installer/modules/ovirt/manifests/postgres...

I''ve followed the tutorial and just don''t get it. How do I connect my ruby/rails sample app to my postgres database. I did follow step 1-4 of the tutorial, I go to step 5: (http://wiki.rubyonrails.org/rails/pages/TutorialStepFive) and try the "rake" commmand and get this: rake aborted! no such file to load -- postgres so I ran with -trace and get this: F:\rubySampleApp>rake -trace ----...

I work on a fairly large website that uses Ruby 1.8.6 and Rails 1.2.3. We cannot upgrade as it will hopelessly break our code. We are working on a new version in Java but for the next year at least we are stuck with the legacy system. We use the latest version of Postgresql for the database using the postgres-pr gem. I am attempting to implement cron tasks within the system using Rufus Scheduler, which is sort of a lighter-weight version of BackgrounDRb. I found very quickly that if I have 2 tasks (threads) running and they both attempt to use ActiveRecord, they d...

Hi, Anyone got any cool tricks for converting a Rails site (in this case, a typo installation) from a mysql database to a postgresql database? I''ve got it almost working -- I''m doing a SQL dump from mysql and loading it into postgres. However, mysql does booleans as a tinyint with 0 = false and 1 = true. When I try to import that into a postgres database that expects booleans to be actual booleans, it fai...

Hi Firstly apologies but i have to install an app that uses postgres but i am more a MySQL/Oracle guy so i maybe doing something really wrong here.. I am following instructions for creating a DB user and encountering this # createuser -ADP -U postgres foo Enter password for new user: Enter it again: createuser: could not connect to database template1: FATAL: ID...

Hi everyone, I run MySQL in my dev environment, but Postgres in my production environment (out of necessity). I''m having trouble finding a way to write a query with a LIKE condition that is supported as case insensitive in both databases. Right now, I have this: @query = "m" # for example @people = Person.find(:all, :conditions =>...

...) assert result.provider_score_is_current I really don''t see the difference between those calls, yet in the latter the field in the result is a boolean, like I would expect, but in the former, it is a string which contains either "t" or "f". Both databasefunctions (postgres) return the type boolean. So what''s the deal? And, I don''t like this way of executing SQL. Running find_by_sql on ActiveRecord::Base doesn''t seem to work. At least, it does at first, but when I want to do something with "result", it says: ActiveRecord::Act...

By default with Rails, Postgres will return the id of a newly inserted record using returning "id". Sometimes when working with Postgres, tables will have triggers on them that modify the row''s data while being saved. As such, it would be great to also provide an option for Postgres to also let insert/upda...