Dave PostgreSQL

/Dave PostgreSQL

How to: Pick a PostgreSQL Python driver

Using Postgres with python is easy and provides first class database capabilities for applications and data processing. When starting a new project, you need to choose which PostgreSQL python driver to use. The best choice depends on your deployment, python version, and background. Here's a quick guide to choosing between three popular python PostgreSQL drivers: [...]

By | January 10th, 2017|Categories: Dave PostgreSQL|Tags: , |8 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

PostgreSQL Replication Checklist

Replication is a key part of creating an "Enterprise" Postgres deployment, to support high availability, failover, disaster recovery, or scale-out queries. Built-in streaming replication was added to PostgreSQL in version 9.0, but the Postgres community has had a number of trigger based replication options for many years, with the big 3 being Slony-I, Londsite, and Bucardo (we're [...]

By | September 28th, 2016|Categories: Dave PostgreSQL|Tags: , , , , |0 Comments

Improve PostgreSQL on Windows performance by 100%

It sounds like click-bait, or one of those late night TV promotions - "Improve your database performance by 100% - by changing just this one setting!" But in this case, it's true - you can drastically improve PostgreSQL on Windows performance by changing one configuration setting - and we made this the default in our [...]

By | September 20th, 2016|Categories: Dave PostgreSQL, OpenSCG|Tags: , , |0 Comments

Read environment variables from PostgreSQL using plpython

Sometimes in your PostgreSQL code you want to read an environment variable - whether to get the input file location for a data load, or check that the postgres user has the right path set, or verify that the TDSDUMP environment variable is set when configuring the tds_fdw to connect to SQL Server. Here's a plpython based [...]

By | September 9th, 2016|Categories: Dave PostgreSQL|Tags: , , |0 Comments