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