BigSQL

/BigSQL

Setting up PL/R with Postgres on Windows

1. Introduction Setting up extra extensions / features on proprietary platform like Windows is a challenge because we don't have a default build environment. Setting up a complete build environment for installing a language extension is bigger challenge. Thanks to vibrant community, many of the heavy lifting is already done. I would like to Acknowledge [...]

By | October 16th, 2017|Categories: BigSQL, Jobin PostgreSQL, PostgreSQL|3 Comments

Connecting SQLServer with Postgres using tds_fdw in easy steps

I have been posting about different types of FDWs available with Postgres distribution by BigSQL. Recently one of our customer had a reqirement of bridging their SQLServer database with Postgres. Postgres by BigSQL is already equiped with it. Here is how we can set it up in simple, easy steps. Step 1. Install FreeTDS in [...]

Hadoop FDW in easy steps

There is good demand for Hadoop integration with Postgres using FDW. Due to same reasonPostgres by BigSQL ships Hadoop FDW package along with other binaries. let me give a quick step by step instruction (with an example) on how to set it up. For preparing these steps, I used Hortonworks VM with Docker. My Hive [...]

By | August 23rd, 2017|Categories: BigSQL, Hadoop, Jobin PostgreSQL|0 Comments

BIG NEWS from BigSQL: Introducing pgDevOps!

To help our colleagues at OpenSCG provide better service to our clients, BigSQL developed pgDevOps - a one stop shop to provision, develop, and monitor PostgreSQL databases. And now... we are making pgDevOps available to the PostgreSQL community! How Does pgDevOps Help? Install and Provision: Package Manager: One-click installs of PostgreSQL [...]

By | March 30th, 2017|Categories: BigSQL, Holly PostgreSQL, OpenSource|Tags: , , , , , , |0 Comments

C++14 and Postgres

The C++ 14 specification came with huge improvements: Auto type deduction, lambdas, movable RValue expressions etc. -- the list is huge. Its a dream come true for lazy programmers like me : write less code & create fewer bugs ;) And get huge performance gains for free. OK this time I thought I'd try some [...]

By | March 28th, 2017|Categories: BigSQL, Jobin PostgreSQL, PostgreSQL Blogs|0 Comments

Extending Postgres by BigSQL

Recently we had a customer request to build a custom extension against Postgres by BigSQL distribution. Even though BigSQL ships with a large set of commonly used extensions and good collection of FDWs, these kind of user build requirements always crop up, based on how powerful the Postgres extension model is. BigSQL makes it easy [...]

By | October 25th, 2016|Categories: BigSQL, Jobin PostgreSQL, PostgreSQL, Uncategorized|0 Comments

Relocatable PG RPMs

Relocatable PostgreSQL RPMs - You asked and we delivered! In our years of dealing with PostgreSQL users, one of the main gripes they have with PostgreSQL is not a missing feature or capability but rather it is the fact that the provided rpms are non relocatable rpms. The reasons for wanting relocatable rpms are many [...]

By | October 19th, 2016|Categories: BigSQL, Dave PostgreSQL, OpenSource|Tags: , , , |0 Comments

Holy Easy PostgreSQL deployment

Holy Easy PostgreSQL deployment! In case you missed it, the BigSQL team released an awesome package manager for installing and configuring PostgreSQL and many related, useful components. The package manager can be found here: https://www.bigsql.org/package-manager.jsp. Playfully named pgc, for ‘pretty good command line’, pgc is a utility similar to yum or apt-get that allows you [...]

By | October 14th, 2016|Categories: BigSQL, Dave PostgreSQL, OpenSCG|Tags: , , , |0 Comments

Auditing database changes using pgaudit

It is a very common requirement in the database world to audit database activities such as Sarbanes-Oxley financial regulations or service level impacts. Reason for auditing, granularity of audit information and type of auditing may differ. The PostgreSQL Audit extension (pgaudit) for Postgres provides most of the necessary features for auditing. The BigSQL project ships [...]

By | October 2nd, 2016|Categories: BigSQL, Jobin PostgreSQL|Tags: , , , |2 Comments