CREATE LANGUAGE plpython3u - PostgreSQL 9.6

This is one of the quickest blog am publishing :). I am publishing from my terminal as is of my testing to create language plpython3u. Using trusted or untrusted distributions of python we can create plpython3u language in PostgreSQL. In my testing, am trying with SCL distribution(am not recommending, I tried for testing) of python3.3 to create language plpython3u. Let’s begin creating language on a binary version of PostgreSQL 9.6 installation without any tweaking.

Continue reading →

ERROR: could not access file "$libdir/plpython2" - ERROR: could not access file "$libdir/plpython3"

Above error described on PG mailing as it failes to CREATE LANGUAGE plpython2u/plpython3u on PG9.3Beta. Error: postgres=# create language plpython3u; ERROR: could not access file "$libdir/plpython3": No such file or directory postgres=# create language plpython2u; ERROR: could not access file "$libdir/plpython2": No such file or directory Before doing some study on above errors I read below PG documentation link on how PostgreSQL permits to create langage plpython and how they should be configured.

Continue reading →

Compiling PL/Proxy with PostgresPlus Advance Server 9.1

PostgresPlus Advance Server 9.1(PPAS) isEnterpriseDB product, which comes with enterprise features as additional with community PostgreSQL. Most of the contrib modules(pgfoundry) can be pluged into this product using Stackbuilder. However,currently Pl/Proxy is not bundled or downloadable with Stack-builder. So,here is how you can compile the Pl/Proxy with PPAS 9.1. Download Pl/Proxy. wget http://pgfoundry.org/frs/download.php/3274/plproxy-2.4.tar.gz tar -xvf plproxy-2.4.tar.gz make PG_CONFIG=/opt/PostgresPlus/9.1AS/bin/pg_config make intall PG_CONFIG=/opt/PostgresPlus/9.1AS/bin/pg_config Note: Flex & Bison must be installed before compiling pl/proxy.

Continue reading →

ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/plperl.so": libperl.so:

Above error thrown, when I was trying to create language plperlu. It indicates that there is a missing library libperl.so. Check out the steps performed to overcome this issue and successfully creating the plperlu language in PostgreSQL. Method 1 (Finding the libperl.so and making softlink to that location) postgres=# create LANGUAGE plperlu; ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory postgres=# \q Now, search for the file libperl.

Continue reading →