Compiling plpgsql_check extension with EDB Postgres 9.6
Published on Tue, Apr 10, 2018

plpgsql_check extension helps developers to validate all embeded SQL and SQL statements inside plpgsql function. Its one of the useful extensions particularly when working with plpgsql development. For more details refer to plpgsql_check documentation. By default, plpgsql_check extension not enabled in community PostgreSQL or commercial EDB Postgres. You need compile the extension with your flavor database. Community PostgreSQL compilation is easy and documented in the above reference link, however below steps help you to compile with commercial EDB Postgres database. Continue reading →

CREATE LANGUAGE plpython3u - PostgreSQL 9.6
Published on Thu, Sep 14, 2017

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 →

How to rotate PgBouncer logs in Linux/Windows ?
Published on Tue, Aug 9, 2016

Before doing a deep dive into the subject, a short outline about PgBouncer, its a¬†lightweight connection pooler for PostgreSQL that dramatically reduces the processing time and resources for maintaining a large number of client connections to one or more databases. Typically used to increase the number of user connections that can be handled in a high performance environment. For more details on Installing/Configuring PgBouncer refer to the documentation¬†here. Continue reading →

Ways to access Oracle Database in PostgreSQL
Published on Wed, May 25, 2016

Today, organizations stores information(data) in different database systems. Each database system has a set of applications that run against it. This data is just bits and bytes on a file system - and only a database can turn the bits and bytes of data into business information. Integration and consolidation of such information(data) into one database system is often difficult. Because many of the applications that run against one database may not have an equivalent application that runs against another. Continue reading →

Compiling write-able mongo_fdw extension on binary format of PostgreSQL installation.
Published on Thu, Jun 25, 2015

A short blog to enable write-able mongo_fdw extension in PostgreSQL 9.4. PostgreSQL provides a powerful feature called Foreign Data Wrappers (FDW), which allows DBAs to connect to other data sources from within PostgreSQL. Foreign Data Wrapper implementation is based on SQL/MED, that’s supported from PostgreSQL 9.1 version onwards, which means we can now access remote database through PostgreSQL seamlessly. Today we have variety of FDW’s available, in this blog, we will be compiling a latest version of write-able FDW “mongo_fdw” to access MongoDB. Continue reading →