Dave Cramer
Dave Cramer
Kubernetes is a very popular container orchestration framework. I’ll show you how to get Symmetric-DS working on a single Kubernetes instance. I had previously explored how to build an active-active PostgreSQL cluster using Symmetric-DS. The steps are essentially the same on Kubernetes: 1. Start 2 PostgreSQL pods 2. Create a user and a database on each pod/instance 3. Start the primary symmetric-ds pod 4. Add the symmetric-ds triggers and routes 5. Open registration 6. Start the secondary s...
Read MorePaul Ramsey
Paul Ramsey
Most businesses have databases of previous customers, and data analysts will frequently be asked to join arbitrary data to the customer tables in order to provide analysis. Unfortunately joining address data together is notoriously difficult: • The same address can be expressed in many ways • The parts of addresses are not always clear • There are valid lexically very similar addresses very nearby any given address The same address can be expressed in many ways The parts of addresses are not alw...
Read MoreChirag Dave
Chirag Dave
The Crunchy PostgreSQL Operator is a controller that runs within a Kubernetes cluster that provides a means to deploy and manage PostgreSQL clusters. pgBackRest is one of the most simple yet powerful backup and restore tools, with a bunch of rich features especially for backing up large databases. At Crunchy Data we have made significant improvements in the PostgreSQL Operator functionality especially for integrating pgBackRest support . This blog post will demonstrate how pgBackRest is we...
Read MoreDouglas Hunley
Douglas Hunley
Crunchy Data has recently announced an update to the CIS PostgreSQL Benchmark by the Center for Internet Security , a nonprofit organization that provides publications around standards and best practices for securing technologies systems. This newly published CIS PostgreSQL 10 Benchmark joins the existing CIS Benchmarks for PostgreSQL 9.5 and 9.6 while continuing to build upon Crunchy Data's efforts with the PostgreSQL Security Technical Implementation Guide (PostgreSQL STIG ). As mention...
Read MoreYogesh Sharma
Yogesh Sharma
One of the most important things to using PostgreSQL successfully in your development and production environments is simply getting started! One of the most popular ways to install PostgreSQL is by using RPM packages. The PostgreSQL RPM packages work across many Linux distributions, including, RedHat Enterprise Linux ( RHEL ), CentOS, Fedora, Scientific Linux, and more, and the PostgreSQL community provides installers for these distributions. This guide will help you get started with install...
Read MoreStephen Frost
Stephen Frost
PostgreSQL provides a bevy of authentication methods to allow you to pick the one that makes the most sense for your environment. One desired implementation that I have found customers wanting is to use Windows Active Directory with PostgreSQL's GSSAPI authentication interface using Kerberos . I've put together this guide to help you take advantage of this setup in your own environment. The first step in setting up a Windows Active Directory is to create a regular user account. The passw...
Read MoreSarah Conway Schnurr
Sarah Conway Schnurr
pgBackRest is an open source tool designed for efficiently performing backups and restores for PostgreSQL on up to terabytes of data at a time. Its aim is to be reliable, scalable, and flexible while offering robust performance during the backup process. Many powerful features are included in pgBackRest, including parallel backup and restore , local or remote operation, full, incremental, and differential backup types , backup rotation, archive expiration, backup integrity, page checksums,...
Read MoreJonathan S. Katz
Jonathan S. Katz
Many applications today record data from sensors, devices, tracking information, and other things that share a common attribute: a timestamp that is always increasing. This timestamp is very valuable, as it serves as the basis for types of lookups, analytical queries, and more. PostgreSQL 9.5 introduced a feature called block range indexes (aka BRIN ) that is incredibly helpful in efficiently searching over large time series data and has the benefit of taking up significantly less space on di...
Read MorePaul Ramsey
Paul Ramsey
New features and better performance get a lot of attention, but one of the relatively unsung improvements in PostGIS over the past ten years has been inclusion in standard software repositories, making installation of this fairly complex extension a "one click" affair. Once you've got PostgreSQL/PostGIS installed though, how are upgrades handled? The key is having the right versions in place, at the right time, for the right scenario and knowing a little bit about how PostGIS works. To exercise...
Read MoreJonathan S. Katz
Jonathan S. Katz
Common table expressions , aka CTEs , aka WITH queries , are not only the gateway to writing recursive SQL queries , but also help developers write maintainable SQL. WITH query clauses can help developers who are more comfortable writing in imperative languages to feel more comfortable writing SQL, as well as help reduce writing redundant code by reusing a particular common table expressions multiple times in a query. A new patch , scheduled to be a part of PostgreSQL 12 major release late...
Read More