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: 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

How to install and configure the Oracle Foreign Data Wrapper

How to install and configure the Oracle Foreign Data Wrapper Preinstall Checklist:    - If you have not already, please download and install "Microsoft Visual C++ 2015 Redistributal" and Java Runtime Environment (version 7 or 8) Oracle Instant Client install and config:           01. Download and unzip into the same directory: [...]

By | April 7th, 2016|Categories: BigSQL|0 Comments

Building PostgreSQL on Windows for Performance

Before PostgreSQL 9.1, adding additional features like data types was non-standard and awkward, but 9.1 brought extensions. By adding extensions as well as the plumbing for things like foreign data wrappers, the use of extensions have exploded over the last few years. This is great for people who are using PostgreSQL on Linux or similar [...]

By | February 17th, 2016|Categories: BigSQL, Jim PostgreSQL, OpenSCG|Tags: , , |3 Comments