Setting R_HOME for PL/R in PostgreSQL in Ubuntu

Email this to someoneShare on Google+Share on FacebookTweet about this on TwitterShare on LinkedIn

Problem

You want to use the PL/R extension in PostgreSQL, and after the package installation you need to set up the R_HOME in PostgresQL.

Solution

Add the following line to the bottom of your PostgreSQL configuration file as sudo: