PostgreSQL

Install PostgreSQL 10 Today

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 [...]

By | May 19th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , , , , |1 Comment

Installing pgDevOps

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 [...]

DevOps: Can’t we just all get along?

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. [...]

By | May 15th, 2017|Categories: Holly 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 [...]

ETL (Extract, Transform, Load) PostGIS Data with ogr2ogr

In an earlier post, I showed you how to use the shp2pgsql tool to import shapefiles into PostGIS. But what if you need to import other geodata formats (e.g. GeoJSON, MapInfo, KML, CSV, etc.)? ogr2ogr - ETL for PostGIS Lucky for you, the BigSQL PostGIS distribution comes bundled with GDAL and the ogr2ogr (or as [...]

By | April 24th, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , , , , |2 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

Proliferation of NUMERIC

More and more I'm seeing people use a NUMERIC for their primary keys. This is a direct result of people leveraging automated tools for their Oracle to PostgreSQL migration. Oracle's NUMBER data type is frequently used as the primary key for a table so the tools just map to a PostgreSQL NUMERIC and calls it [...]

By | March 20th, 2017|Categories: Jim PostgreSQL|Tags: , , , |4 Comments

Migrations: What applications should I migrate?

When you have made the decision to investigate migrating your database applications from one database platform to another, the next big question you will need to answer is ‘Which application(s)?’ It seems like an easy enough question but there are many variables involved in whether or not the migration will be smooth. Technically, any application [...]

By | March 9th, 2017|Categories: Migration, OpenSCG, PostgreSQL|Tags: , , |0 Comments