Shaun's PlanetPostgreSQL Archives - Page 2 of 3 - 2ndQuadrant

On Rocks and Sand

September 21, 2018/10 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

When working with database capacity planning, there are a lot of variables to consider, and Postgres is no different in this regard. One of the elements which requires management is storage. However, there’s an aspect of storage that escapes inspection almost without exception, and it’s hiding in the shadows between the columns themselves. Alignment Basics […]

[Video] Data Integration with PostgreSQL

August 30, 2018/4 Comments/in PostgreSQL, Shaun's PlanetPostgreSQL /by Shaun Thomas

Just in case you missed the live broadcast, the video of my presentation below covers various topics around integration of PostgreSQL with other data sources and database technologies. This presentation covers the following topics: What is a Foreign Data Wrapper? How to query MySQL, a Flat file, a Python script, a REST interface and a […]

PG Phriday: BDR Around the Globe

May 4, 2018/2 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

With the addition of logical replication in Postgres 10, it’s natural to ask “what’s next”? Though not directly supported yet, would it be possible to subscribe two Postgres 10 nodes to each other? What kind of future would that be, and what kind of scenarios would be ideal for such an arrangement? As it turns […]

PG Phriday: Securing PgBouncer

April 20, 2018/1 Comment/in Shaun's PlanetPostgreSQL /by Shaun Thomas

We all love PgBouncer. It’s a great way to multiplex tens, hundreds, or even thousands of client connections to a small handful of Postgres sessions. What isn’t necessarily so endearing, is that it can’t pass authentication from itself to Postgres, as each Postgres session may exist before the connection to PgBouncer is established. Or can […]

PG Phriday: Adventures in BAR Management

January 19, 2018/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

Backups are a critical component to a fully covered Postgres database infrastructure. In some ways, it’s fair to say a database without a backup is no database at all—sometimes literally. 2ndQuadrant’s Barman tool is aptly named as a Backup And Recovery Manager for Postgres, and it exists primarily for encouraging a stable and robust backup […]

PG Phriday: Postgres on ZFS

December 29, 2017/22 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

ZFS is a filesystem originally created by Sun Microsystems, and has been available for BSD over a decade. While Postgres will run just fine on BSD, most Postgres installations are historically Linux-based systems. ZFS on Linux has had much more of a rocky road to integration due to perceived license incompatibilities. As a consequence, administrators […]

PG Phriday: Getting RAD with Docker [Part 4]

December 8, 2017/5 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

PgBouncer is a popular proxy and pooling layer for Postgres. It’s extremely common to reconfigure PgBouncer with repmgr so it always directs connections to the current primary node. It just so happens our emerging Docker stack could use such a component. In our last article, we combined Postgres with repmgr to build a Docker container […]

PG Phriday: Getting RAD with Docker [Part 3]

November 24, 2017/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

Building an Immortal Cluster By now we’ve learned about basic Postgres Docker usage and rudimentary clustering. For the uninitiated, constructing a Postgres cluster can be a daunting task, and we’ve greatly simplified the process. So why don’t we take the next logical step and use Docker to deploy a cluster that is effectively immortal as […]

PG Phriday: Getting RAD with Docker [Part 2]

November 10, 2017/4 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

In our last article, we explored how to run Postgres in some very basic Docker scenarios. Based on our experiments back then, we can obtain images, create containers, and mount to various types of storage. Boring! It’s not just boring, it’s mundane. It doesn’t do anything. Sure we can run Postgres in a container, but […]

PG Phriday: Getting RAD with Docker [Part 1]

October 20, 2017/6 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

Fans of Rapid Application Development (RAD!) are probably already familiar with Docker, but what does that have to do with Postgres? Database-driven applications are a dime a dozen these days, and a good RAD environment is something of a Holy Grail to coders and QA departments alike. Docker lets us spin up a Postgres instance […]

2ndQuadrant is now part of EDB