Magistrate Postgres Stats for Developers

Magistrate Postgres Blog

Set Postgres System Timezone

A quick guide on how to set Postgres system timezone in a way that works across restarts.
Read full article

Using pg_repack in AWS RDS

Tables can get larger over time due to database bloat. Pg_repack is a way to correct the tables size and this post gets you going with pg_repack and AWS RDS.
Read full article

Storing Timezones in Postgres

Storing a user’s timezone in Postgres can be an interesting task in apps. Postgres has some built-in utilities to make this much easier.
Read full article

Postgres 2020 Q3 Release

Another patch for postgres has landed. This patch moves the latest secure version to pg 12.4, 11.9, pg 10.14 and pg 9.6.19. The highlight of this release is fixing CVE-2020-14349 and CVE-2020-14350, which allowed unintended privilege escalation under certain conditions.

Read full article

Case-Insensitive Text Columns in Postgres with citext

We are going to leverage a Postgres extension to get access to a new column type, citext (case insensitive text).
Read full article

Branching Out Into Hierarchy Data

ltree is a Postgres extension that can give you and your application a lot of options around complex hierarchal relationships.

Read full article

Gravatars and Postgres 12 using Generated Columns

Generated columns are an exciting new feature of Postgres. They allow you to replace some of your existing trigger logic in a faster and easier to read way.
Read full article

Knex.js and Postgres

Knex.js is a SQL query builder based on Laravel Query Builder. It supports a handful of different databases, most importantly Postgres. It has been my first choice for database interaction in JavaScript for years.

Read full article

Postgres 2020 Q2 Release

Another patch for postgres has landed. This patch moves the latest secure version to pg 12.3, 11.8, pg 10.13 and pg 9.6.18. The highlight of this release is fixing CVE-2020-10733, which allowed unintended execution behavior on Windows systems.

Read full article

Postgres 2020 Q1 Release

Another patch for postgres has landed. This patch moves the latest secure version to pg 12.2, 11.7, pg 10.12 and pg 9.6.17. The highlight of this release is fixing CVE-2020-1720, which allowed privilege escalation attacks through extensions installed/configured in a certain way.

Read full article

Postgres 2019 Winter Release

Another patch for postgres has landed. This patch moves the latest secure version to pg 12.1, 11.6, pg 10.11 and pg 9.6.16. The highlight of this release is fixing a lot of bugs found in the initial release of Postgres 12.

Read full article

Postgres 2019 Summer Security Release 2

Another patch for postgres has landed. This patch moves the latest secure version to pg 11.5, pg 10.10 and pg 9.6.15. The highlight of this release is fixing a security issue around executing arbitrary SQL during SECURITY DEFINER execution as well as over 40 other bug fixes.

Read full article

Postgres 2019 Summer Security Release

Another patch for postgres has landed. This patch moves the latest secure version to pg 11.4, pg 10.9 and pg 9.6.14. The highlight of this release is fixing a security issue around triggering a stack-based buffer overflow through via setting a password as well as a number of other bug fixes.

Read full article

Postgres 2019 Spring Security Update

Another patch for postgres has landed. This patch moves the latest secure version to pg 11.3, pg 10.8 and pg 9.6.13. The highlight of this release is fixing security issues on the Windows Operating System as well as a number of other bug fixes.

Read full article

Postgres 2019 Spring Update

Another patch for postgres has landed. This patch moves the latest secure version to pg 11.2, pg 10.7 and pg 9.6.12. The highlight of this release is the behavior change to fsync.

Read full article

Postgres 2018 Winter Update

Another patch for postgres has landed. This patch moves the latest secure version to pg 10.6 and pg 9.6.11. This release was a security release as well as a handful of other improvements

Read full article

Postgres 2018 Summer Update

Another patch for postgres has landed. This patch moves the latest secure version to pg 10.5 and pg 9.6.10. In addition to 2 CVE's being patched, there are a handful of improvements in this update.

Read full article