Comments on blog.PaplooTheLearned.net: Tip: Compiling the Postgres Gem for Ruby 1.9.1

i tried ruby-pg and i applied the explanation abov...

2010-07-22T15:17:23.802-07:00

i tried ruby-pg and i applied the explanation above and works fine.

thanks

@val2many: Yeah, I figured that out after getting ...

2010-05-11T10:12:03.281-07:00

@val2many: Yeah, I figured that out after getting a bug report reply from the pg team. I edited the the post about 6 months ago with a note at the top bout that. :)

"gem install pg" works for me on Debian ...

2010-05-11T00:09:53.229-07:00

"gem install pg" works for me on Debian with no trouble at all.
You probably figured, but I thought I'd mention ...

@Anonymous on February 4, 2010 6:18 PM: It sounds...

2010-02-04T18:35:11.813-08:00

@Anonymous on February 4, 2010 6:18 PM:

It sounds like you have a conflict going on. You may want to remove all instances of the previous postgres gem and see if that makes pg work. (I'd advise switching to it if you can!)

If it is still overriding, it is also possible that there is an installation of a postgres gem in an odd place that is overriding yours. (This sounds odd, but I've seen this happen on non-standard installs).

Amazingly enough (or not?) I was doing a fresh ins...

2010-02-04T18:18:32.094-08:00

Amazingly enough (or not?) I was doing a fresh install with pg and was still getting the error.

Well, I should say that installing pg worked fine, but when trying to start rails I kept getting a pg does not exist error. But both pg and postgres show the exact same gem when installed. Paths are set correctly, etc.

So I ran your patch and now my server boots fine. Go figure!

Either way, thank you!

You can use 'sed -i' to edit a file in pla...

2009-09-24T12:55:06.575-07:00

You can use 'sed -i' to edit a file in place. No need to type the filename twice.

In response to lobo: All you need to do to get th...

2009-08-28T07:52:21.937-07:00

In response to lobo:

All you need to do to get this running on Ubuntu 9.04 is direct the sed commands to temporary files and then move them over the originals.

$ cd /usr/local/lib/ruby/gems/1.9.1/gems/postgres-0.7.9.2008.01.28/ext
$ sudo sed "s/PLATFORM/RUBY_PLATFORM/" extconf.rb > ./extconf.bck
$ sudo mv extconf.bck extconf.rb
$ sudo ruby extconf.rb
$ sudo sed "s/RARRAY($[_a-zA-Z0-9]*$)->ptr/RARRAY_PTR(\1)/; s/RARRAY($[_a-zA-Z0-9]*$)->len/RARRAY_LEN(\1)/; s/row->len/RARRAY_LEN(row)/; s/row->ptr/RARRAY_PTR(row)/" postgres.c > ./postgres.bck
$ sudo mv postgres.bck postgres.c
$ sudo make
$ sudo make install

Thanks for advice on how to get this working Paploo, very handy.

I had to chmod my extconf.rb file so I can write i...

2009-07-26T16:39:14.751-07:00

I had to chmod my extconf.rb file so I can write in it (sudo wouldn't cut it).

After that, the first sed command, truncates the file to 0 bytes.

I'm on Ubuntu 9.04, do you know what's going on?