# Q: postgres access in Windows

**URL:** <https://www.ruby-forum.com/t/q-postgres-access-in-windows/144304>\
**Category:** Ruby\
**Created:** [July 28, 2008, 2:15pm UTC](https://www.ruby-forum.com/t/q-postgres-access-in-windows/144304 "2008-07-28T14:15:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![GSRalph\_KuntzS\_MD](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/c89c15/32.png) [@GSRalph\_KuntzS\_MD](https://www.ruby-forum.com/u/GSRalph_KuntzS_MD)\
**Post date:** [July 28, 2008, 2:15pm UTC](https://www.ruby-forum.com/t/q-postgres-access-in-windows/144304/1 "2008-07-28T14:15:23Z")

</div>

I spent a couple of hour this weekend trying to get Ruby to talk to  
PostgreSQL on a Windows Vista machine without success. I am working  
with both Cygwin Ruby and JRuby.

I installed the DBI gem, including dbd\_pg. I get the following error  
in both version of Ruby:

```
Could not load driver (no such file to load -- /usr/lib/ruby/

```

site\_ruby/1.8/dbd/Pg)

I also tried jruby-postgres and pgconn but I could not figure out how  
to call the first one and got errors with the second. I could not  
find any documentation (even tried ri).

I tried Googling everything I could think of.

Has anyone gotten a DB connection to PostgreSQL working under Windows  
with any version of Ruby?

Thanks.

---

<div class="post-metadata">

**Author:** ![GSRalph\_KuntzS\_MD](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/c89c15/32.png) [@GSRalph\_KuntzS\_MD](https://www.ruby-forum.com/u/GSRalph_KuntzS_MD)\
**Post date:** [July 28, 2008, 2:48pm UTC](https://www.ruby-forum.com/t/q-postgres-access-in-windows/144304/2 "2008-07-28T14:48:49Z")

</div>

On Mon, Jul 28, 2008 at 2:14 PM, G. Ralph Kuntz, MD, MS [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> I also tried jruby-postgres and pgconn but I could not figure out how

Hi,

My current use of postgres is done like this (but I think you can  
require ‘dbi’ instead of ‘rubygems’):

require ‘rubygems’  
require ‘postgres’

$conn =  
PGconn.connect(‘hostname’,‘port’,‘’,‘’,‘db-name’,‘username’,‘password’)

If you’ve installed rails you can also do the following in order to  
use ActiveRecord which is nice:

require ‘rubygems’  
require ‘active\_record’

ActiveRecord::Base.pluralize\_table\_names = false  
ActiveRecord::Base.establish\_connection(  
:adapter =\> “postgresql”,  
:host =\> “hostname”,  
:database =\> “db-name”,  
:username =\> “username”,  
:password =\> “password”  
)

And then create objects of tables or views.  
Assuming you have a table or a view called gen\_table:

class GenTable \< ActiveRecord::Base; end  
gt = GenTable.find(:all)

for a in gt  
puts a.id  
end

---

<div class="post-metadata">

**Author:** ![GSRalph\_KuntzS\_MD](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/c89c15/32.png) [@GSRalph\_KuntzS\_MD](https://www.ruby-forum.com/u/GSRalph_KuntzS_MD)\
**Post date:** [July 28, 2008, 7:47pm UTC](https://www.ruby-forum.com/t/q-postgres-access-in-windows/144304/3 "2008-07-28T19:47:09Z")

</div>

That worked like a charm!

Is there any documentation on PGconn and the other classes in the  
postgres-pr module?

Thanks.