Dave PostgreSQL

/Dave PostgreSQL

Mapping Oracle to PostgreSQL data types

A common first question during a database migration is "How do Oracle datatypes compare to PostgreSQL?" The simple answer is that they are very compatible, and map easily. The table below shows an Oracle to PostgreSQL data type comparison and mapping for the most common Oracle types. These basic data types just scratch the surface [...]

By | August 10th, 2017|Categories: Dave PostgreSQL|Tags: , , , |0 Comments

Autonomous transactions using pg_background

Transactions are an important feature in any database and PostgreSQL has them. We want to be "ACID Compliant" and ensure that all data is read and written in a consistent state. All changes in the transaction either commit or rollback together. You never change just one table, without also changing all the other related tables [...]

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