How to Upgrade Your PostgreSQL Passwords to SCRAM

In a lot of PostgreSQL environments, it’s common practice to protect user accounts with a password. Starting with PostgreSQL 10, the way PostgreSQL manages password-based authentication got a major upgrade with the introduction of SCRAM authentication, a well-defined standard that is a significant improvement over the current system in PostgreSQL. What’s better is that almost […]

The Guardian’s Migration from MongoDB to PostgreSQL on Amazon RDS

The Guardian migrated their CMS’s datastore in 2018 from a self-managed MongoDB cluster to PostgreSQL on Amazon RDS for a fully managed solution. The team did an API-based migration without any downtime. Guardian’s in-house CMS – called Composer – which stores articles, blog content, photo galleries and video was originally built on top of MongoDB […]

PostgreSQL across clouds and on-premises

PostgreSQL is a very popular open source relational database. It’s been in active development for over 30 years and has achieved a very high level of reliability and performance, as well as a very robust feature set. If your applications make use of PostgreSQL, you’ll now be able to use Crossplane to deploy both your […]

Bye bye Mongo, Hello Postgres

In April the Guardian switched off the Mongo DB cluster used to store our content after completing a migration to PostgreSQL on Amazon RDS. This post covers why and how At the Guardian, the majority of content – including articles, live blogs, galleries and video content – is produced in our in-house CMS tool, Composer. […]

How ShiftLeft Uses PostgreSQL Extension TimescaleDB

Time series are a major component of the ShiftLeft runtime experience. This is true for many other products and organizations too, but each case involves different characteristics and requirements. This post describes the requirements that we have to work with, how we useTimescaleDBto store and retrieve time series data, and the tooling we’ve developed to […]

Introducing Patroni as the Postgres Failover Manager on GitLab.com

We are writing this post to let our community know we are planning on performing the work necessary to deploy Patroni as the Postgres Failover Manager on GitLab.com over two weekends: a dry-run to test our migration plan and tools on Saturday, Dec 8, 2018, and the actual deployment on Saturday, December 15, 2018. Source: […]