From: Michael Neumann <mneumann@...>
Date: 2005-01-07T22:16:14+09:00
Subject: Re: postgres-pr

Ernest Ellingson wrote:
> Thanks Michael
> I'm still not sure about Pg.rb.  Where is it?  It's not in the DBI or 
> the DBD directory.  Does it exist?  How do I get it?

Ah, okay. I think it's not bundled with the Windows-Installer, as you 
need the postgres.so or postgres-pr libraries. And postgres.so is/was 
not available for Windows AFAIK.

You can download it from here:

http://ntecs.de/viewcvs/viewcvs/dbd-pg/trunk/src/?root=ruby-dbi

Just put the Pg.rb into the DBD/Pg directory (create the Pg directory).

> As for postgres-pr I tried the test_connection.rb code changed the uri 
> to 'tcp://ipaddress:5432' and the other parameters to appropriate 
> values.  Apparently a connection is being made but the same blow up in 
> page files occurs 1.25 GB's.  The program finally errors out with this 
> trace. I should mention the database is on another machine running RH 
> linux 9 and postgresql 7.4.

Hm, very strange. Does using TCPSockets generally work on your platform 
without problems?

> c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.3.3/lib/buffer.rb:64:in 
> `read': failed to allocate memory (NoMemoryError)

I should include some debug code. It might be, that there's a negative 
buffer-length which gets interpreted as an unsigned value... or 
something like this. You're on a 32-bit machine, right?

Regards,

   Michael