Installing untrusted PL/Ruby for PostgreSQL
55 comments Latest by chanel handbags online Wed, 25 Aug 2010 09:43:21 GMT
This is going to be short and sweet.
“PL/Ruby is a loadable procedural language for the Postgres database system that enable the Ruby language to create functions and trigger procedures”
Method 1. The standard, safe, PL/Ruby.
Before running this, you need to have all the PostgreSQL headers installed. (se INSTALL in the postgresql directory)make install-all-headers
To install PL/Ruby, you need to download the tarball from here. As you can see, I download it with wget and then install like I would any ruby library. (maybe plruby could become a gem?)
cd /usr/local/src
wget ftp://moulon.inra.fr/pub/ruby/plruby.tar.gz
tar zxvf plruby.tar.gz
cd plruby
ruby extconf.rb
make
make install
Method 2: The untrusted, but super cool PL/Ruby.
Guy Decoux, author of PL/Ruby, was kind enough to share a secret about the PL/Ruby install. (from his email…)
Well plruby normally run with $SAFE = 12, this value if fixed at compile time. Now it has an undocumented option, if you compile it with ruby extconf.rb --with-safe-level=0 ... it will run with $SAFE = 0 and you have the equivalent of an untrusted language.
Pretty simple solution, eh?
On my server I was able to run the following:
cd /usr/local/src
wget ftp://moulon.inra.fr/pub/ruby/plruby.tar.gz
tar zxvf plruby.tar.gz
cd plruby
sudo ruby extconf.rb \ --with-pgsql-dir=/usr/local/pgsql-8.0 \ --with-safe-level=0 \ --with-suffix=u
make
make install
Update: the --with-suffix=u was added after someone commented on this. This allows you to install plruby and plrubyu.
Installing PL/Ruby in PostgreSQL Up until now, you haven’t actually installed the language into the database. We’re close though!
All that you need to do is run the following commands to install it to a specific database in your server.
$ psql template1
template1=# CREATE DATABASE plruby;
CREATE DATABASE
template1=# \c plruby
You are now connected to database "plruby".
plruby=# create function plruby_call_handler() returns language_handler
plruby-# as '/usr/lib/site_ruby/1.8/i386-linux/plruby.so'
plruby-# language 'C';
CREATE FUNCTION
plruby=# create language 'plruby'
plruby-# handler plruby_call_handler
plruby-# lancompiler 'PL/Ruby';
CREATE LANGUAGE
plruby=#
That should be all there is to it!
Where do we go from here?
See my post: PL/Ruby loves RubyGems and DRb
Enjoying the content? Be sure to subscribe to my RSS feed.
I’ve been searching for a whole day to find out how to do this…. great post! Thanks :)
Great post, any ideas on how to make PL/RUBY for enterprisedb -v 8.2?
[configure runs w/o errs] ruby extconf.rb —with-pgsql-lib=/opt/enterprisedb/8.2/dbserver/lib—with-pgsql-include=/opt/EnterpriseDB/8.2/dbserver/include/server/—with-safe-level=0
[however mkmf.log reports:] have_func: checking for rb_block_call()... —-—-—-—- no have_header: checking for server/utils/array.h… —-—-—-—- no
—-—-—-—-—-—-—-—-—-- Make reports (2) errs that point to missing array.h
Thanks!
very nice thx
Tall Christian Louboutin Boots 海外有名なブランドバッグ販売送料無料 Air Jordan 3 (III)
YSL Platform Pumps&Slingbacks 海外有名なブランド小物コピー Air Jordan 4 (IV)
I am very picky shoes, sometimes I feel that very few seem to fit right or comfortable shoes. One day, I know a certain site christian louboutin shoes. I have read christian louboutin shoes! I think I can never afford these christian louboutin shoes, but did not clean christian louboutin shoes on it! These shoes provide such wonderful support and comfort me. They are christian louboutin shoes online, and with the project is amazing. They really tempted, I finally decided to buy a pair. Strongly recommended! http://www.christianlouboutinshoes-mall.com">christian louboutin http://www.christianlouboutinshoes-mall.com">louboutin shoes http://www.christianlouboutinshoes-mall.com">christian louboutin shoes
MP5 Player 2GB MP5 4GB MP5 8GB MP5
MP5 Player 2GB MP5 4GB MP5 8GB MP5
Touch Screen LCD Monitor 7” Touch Screen LCD Monitor 8” Touch Screen LCD Monitor 10.4” Touch Screen LCD Monitor
If you are looking for the best brand new laptop batteries at the most preferred price, you have come to the right place. We provide the highest quality Battery at the lowest price with the highest level of service, all in a secure and convenient platform.
http://www.adapterlist.com/hp/pavilion-dv2000.htm HP pavilion dv2000 Battery http://www.adapterlist.com/hp/pavilion-dv6000.htm HP pavilion dv6000 Battery http://www.adapterlist.com/hp/dv2000.htm hp dv2000 battery
thank you for this outstanding article.I thought certino was the best technologh for laptop battery performance. http://www.globallaptopbattery.co.uk/hp/510.htm Hp 510 Battery http://www.globallaptopbattery.co.uk/hp/530.htm Hp 530 Battery http://www.globallaptopbattery.co.uk laptop batteries
cooooooool. Acer as07b31 Battery Acer as07b32 Battery Acer as07b41 Battery Acer as07b42 Battery Acer as07b51 Battery Acer as07b52 Battery Acer as07b71 Battery Acer as07b72 Battery Acer aspire 5520 Battery Acer aspire 5920 Battery Acer aspire one zg5 Battery Acer bat30n3l Battery
http://www.bestlaptopbattery.co.uk laptop batteries
Dell gd761 Battery Dell gk479 Battery Dell gw240 Battery
Rich People Copy Life Gold Mine Bar Products Fever Theme Posh Craze Well done!
you haven’t actually installed the language into the database.
http://www.ed-hardy-outlet.net/ ED hardy clothing http://www.ed-hardy-outlet.net/ ED Hardy Outlet http://www.ed-hardy-outlet.net/ online ED Hardy
Hello,I love reading through your blog, I wanted to leave a little comment to support you and wish you a good continuation. Wishing you the best of luck for all your blogging efforts. car dvd laptop ac adapter
BNFCGBFG
GF
mbt women’s chapa gore-tex
supra suprano blue white orange
air jordan 14
RTYRTYRTY
http://www.adapterlist.com/hp/nc8230.htm hp nc8230 battery
RETRETERT
RT
cooooooool. Acer as07b31 Battery Acer as07b32 Battery Acer as07b41 Battery Acer as07b42 Battery Acer as07b51 Battery Acer as07b52 Battery Acer as07b71 Battery Acer as07b72 Battery Acer aspire 5520 Battery Acer aspire 5920 Battery Acer aspire one zg5 Battery Acer bat30n3l Battery
ty ut
Thanks for sharing this article…it was very nice…
Thanks for sharing this article…it was very nice…
It is a good chance for you toed hardy t shirts buy now .Nowadays ,we published a new kind of Air Jordan ,that is the Air Jordan Force line .They are so good that when you see it , you will likechi hair straightener it and are willing to own
Thanks for sharing this article…it was very nice… 1 canon powershot sd630 charger 2 canon powershot s40 charger 3 canon nb-1lh charger 4 canon nb-2lh charger 5 canon nb-4l charger 6 canon nb-4l battery 7 canon mv750i battery 8 canon nb-5l battery 9 canon nb-4l charger 10 canon powershot sd890 battery 11 canon nb-5l battery 12 canon bp-808 battery 13 canon nb-2l battery
iron on transfer Jewish Directory Bar Mitzvah Wholesale menu keep jersey city shenzhen direct shenzhen discount shenzhen buy shenzhen city affiliate promos bars cash disco tumblr city star jar twink pinoy agency oak bar stool bar accessories Flair Bartending Posi Pourers
Thanks a lot for enjoying this beauty article with me. I am apreciating it very much! Looking forward to another great article. Good luck to the author! all the best!
vI was starting to wonder if you’d fell and hit your head and forgot everything that you knew about Ruby on Rails. Underneath the same code is getting called whether is be the plugin or the code in the view.
They are so good that when you see it , you will like it and are willing to own <a href=”http://www.batterychargershop.co.uk/panasonic/dmc-tz4/battery+charger.htm ”>panasonic dmc-tz4 charger
<a href=”http://www.batterychargershop.co.uk/panasonic/pv-dac13/battery+charger.htm ”>panasonic pv-dac13 charger
<a href=”http://www.batterychargershop.co.uk/panasonic/pv-dac14/battery+charger.htm ”>panasonic pv-dac14 charger
[url=http://www.all-good-batteries.com/panasonic/cga-du14/camcorder+battery.htm ]panasonic cga-du14 battery[/url]
They are so good that when you see it , you will like it and are willing to own http://www.batterychargershop.co.uk/panasonic/dmc-tz4/battery+charger.htm ”>panasonic dmc-tz4 charger
http://www.batterychargershop.co.uk/panasonic/pv-dac13/battery+charger.htm ”>panasonic pv-dac13 charger
http://www.batterychargershop.co.uk/panasonic/pv-dac14/battery+charger.htm ”>panasonic pv-dac14 charger
They are so good that when you see it , you will like it and are willing to own http://www.start-battery.com/fujifilm/np-70/digital+camera+battery.htm”>fujifilm np-70 battery http://www.start-battery.com/fujifilm/np-80/digital+camera+battery.htm”>fujifilm np-80 battery
Looking forward to another great article. Good luck to the author! all the best! s
Today is another day.All things goes bad,no special.However,do what I want to,but I don’t know how and what should I do.As the saying goes.you are only young once,it’ makes me frightened about the passed days.I got nothing after I have tried so hard.
grey jordan p90x workout ,px90 , p90x nutrition ,p90x fitness ,p90x extreme ,p90x reviews ,p90x schedule ......
To the dismay of the abercrombie and fitch Outlet empire, teenagers whose parents have cut back on their allowances may be coming to a recessionary revelation: Abercrombie and fitch Paying $90 for torn jeans isn’t that cool anymore.While other retailers are responding to the downturn with red-lined price tags and tempting promotions, upscale Abercrombie & Fitch isn’t budging Abercrombie sale on its price points. This scarf, for example, will still cost you $58. The company is fiercely protecting its image as a “premium” brand, and, as a result ed hardy , it’s getting snubbed big time by its once cultlike, ever-loyal fan base Christian Audigier
http://www.winbatterycharger.com/nikon-d40-battery-charger-imhn.htm”>nikon d40 battery charger. Discount nikon d40 battery charger. We offer best battery charger for nikon d40 with Fast delivery!
<a href=”http://www.batterychargershop.co.uk/samsung/sc-hmx10c/battery+charger.htm ”>samsung sc-hmx10c charger
[url=http://www.all-good-batteries.com/jvc/bn-v11u/camcorder+battery.htm ]jvc bn-v11u battery[/url]
http://www.powerchargerbattery.com/jvc-bn-vf707u-camcorder-battery-cb.htm jvc bn-vf707u battery http://www.powerchargerbattery.com/jvc-gz-mg630-battery-charger-cb.htm jvc gz-mg630 charger http://www.powerchargerbattery.com/panasonic-cga-s002e-digital-camera-battery-cb.htm panasonic cga-s002e battery http://www.powerchargerbattery.com/nikon-en-el7-digital-camera-battery-cb.htm nikon en-el7 battery
Very good article, I have introduced many friends read your article.
procedural language for the Postgres database system that enable the Ruby language to create functions and trigger procedures”
Thanks for your suggestions. I think I have known how to do it. coach wallet
We are a professional exporter and wholesaler of brand fashion products,Herve Leger Black Wide V neck Bandage Dress Herve Leger Black Deep V neck Bandage Dress Herve Leger Black Cap-Sleeve Bandage Dress Herve Leger Deep Green Dress Herve Leger Scoopneck Tank Pink Dress，All products have good quality,fast and safe delivery without shipping fee. Our primary goal is to meet our clients’ requirement and establish mutually pleasant business relationships with you.If you are interested, please do not hesitate to contact us.
We are a professional exporter and wholesaler of brand fashion products,Coach Spotlight Handbags 13819 White Coach Tribeca Op Art Sateen Hobo Handbag 14127 Apricot Coach Tribeca Op Art Sateen Hobo Handbag 14127 Black Coach Tribeca Op Art Tote Handbags 14138 Brown Coach Vogue Lady’s Handbags，All products have good quality,fast and safe delivery without shipping fee. Our primary goal is to meet our clients’ requirement and establish mutually pleasant business relationships with you.If you are interested, please do not hesitate to contact us.
We are a professional exporter and wholesaler of brand fashion products,Coach Spotlight Handbags 13819 White Coach Tribeca Op Art Sateen Hobo Handbag 14127 Apricot Coach Tribeca Op Art Sateen Hobo Handbag 14127 Black Coach Tribeca Op Art Tote Handbags 14138 Brown Coach Vogue Lady’s Handbags，All products have good quality,fast and safe delivery without shipping fee. Our primary goal is to meet our clients’ requirement and establish mutually pleasant business relationships with you.If you are interested, please do not hesitate to contact us.
Definitely agree with what you stated. Your explanation was certainly the easiest to understand. I tell you, I usually get irked when folks discuss issues that they plainly do not know about. You managed to hit the nail right on the head and explained out everything without complication. Maybe, people can take a signal. Will likely be back to get more. Thanks http://homeacneremedy.wordpress.com/
One of the more impressive blogs Ive seen. Thanks so much for keeping the internet classy for a change.