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