Dear debian list members,
I want to access a postgresql database server from within a ruby script and 
installed the following packages:

~$ dpkg -l | grep ruby
ii  libpgsql-ruby1.8                     0.7.9.2008.03.18-2         PostgreSQL 
interface for Ruby 1.8
ii  libruby1.8                           1.8.7.72-3lenny1           Libraries 
necessary to run Ruby 1.8
ii 
 ruby                                 4.2                        An interpreter 
of object-oriented scripting language Ruby
ii  ruby1.8                              1.8.7.72-3lenny1           Interpreter 
of object-oriented scripting language Ruby 1.8

My script looks like this:

#!/usr/bin/ruby
require "postgres"

  puts "Starting................"
  dbname="abc"
  start="2004-08-06"
  end="2004-10-14"
 #make connection
 
 conn = PGconn.connect("localhost",5432,"","",dbname,"user","password")

However, I get the following error:

maakklassen.rb:9:in `require': no such file to load -- postgres (LoadError)
        from maakklassen.rb:9

My postgresql related packages are:
dpkg -l | grep postgres
ii  postgresql                           8.3.11-0lenny1             
object-relational SQL database (supported version)
ii  postgresql-8.3                       8.3.11-0lenny1             
object-relational SQL database, version 8.3 server
ii  postgresql-client                    8.3.11-0lenny1             front-end 
programs for PostgreSQL (supported version)
ii  postgresql-client-8.3                8.3.11-0lenny1             front-end 
programs for PostgreSQL 8.3
ii  postgresql-client-common             94lenny1                   manager for 
multiple PostgreSQL client versions
ii  postgresql-common                    94lenny1                   PostgreSQL 
database-cluster manager
ii  postgresql-contrib                   8.3.11-0lenny1             additional 
facilities for PostgreSQL (supported version)
ii  postgresql-contrib-8.3               8.3.11-0lenny1             additional 
facilities for PostgreSQL
ii  postgresql-doc                       8.3.11-0lenny1             
documentation for the PostgreSQL database management system
ii  postgresql-doc-8.3                   8.3.11-0lenny1             
documentation for the PostgreSQL database management system


What am I doing wrong here?

Brgds
Dino







      

Reply via email to