Shout out goes to Regina Obe and Paul Ramsey for their work and documentation on ogr_fdw. The ogr_fdw project can be found here: https://github.com/pramsey/pgsql-ogr-fdw. ogr+fdw = ogr_fdw In an earlier post, I showed you how to use the ogr2ogr (or as my geogeek friends like to call it "ogre to ogre") command line tool to [...]
Hey, have you heard? PostgreSQL 10 Beta is road ready! Kick the tires and take the cool new features and improvements out for a spin. Highlights include: Declarative Partitioning Logical Replication SCRAM Authentication See the full list of features here. Take the easy route Never used the BigSQL PostgreSQL Distributions before? Follow these 5 easy [...]
Install in 6 easy steps Never used the BigSQL PostgreSQL Distributions before? Follow these 5 easy steps. Already have BigSQL pgc installed? Jump to step #3. Read this short introduction to BigSQL's package and update manager (pgc). Install pgc via command line to a sandbox: MAC / Linux: python -c "$(curl -fsSL http://s3.amazonaws.com/pgcentral/install.py)" Windows: @powershell [...]
pgDevOps will help your developers and operations teams work collaboratively, efficiently, and openly. To understand the value added when you include pgDevOps in your PostgreSQL tool-chain, keep reading. tldr; Go straight to the tutorial to start using pgDevOps today! Why DevOps: A brief explainer First a little background to better understand why BigSQL built pgDevops. [...]
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 [...]
When you want to copy all the records from one table to another - for example, to change the data model or my favorite migrate data from a foreign table to a local PostgreSQL, you want to use multiple batches to avoid a long running transaction or the need to restart from the beginning in [...]
I gave a talk at the PG Conf US 2017 titled "Columns and Clouds" that covered PostgreSQL partitioning, foreign data wrappers, using column store (c-store) and remote cloud based partitions. The Slides (in PDF) for the talk are here.