Monthly Archives: May 2017

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