Andrew Dunstan

Andrew Dunstan is a Senior Principal Engineer at EDB. He has been contributing to the PostgreSQL project for more than 20 years, and for most of that time has been one of the project's core committers.

Among the features he has contributed to are the Windows port, CSV import and export, parallel pg_restore, and the JSON and JSONB data types and associated functions. In 2004 he created the PostgreSQL Build Farm, which he still maintains.

Andrew joined 2ndQuadrant in 2016 and EDB in 2020 when it acquired 2ndQuadrant.

Read Blogs

Technical Blog

Problem with Buildfarm registrations fixed

Recently we switched the PostgreSQL Buildfarm to use https for its front-facing web transactions. That’s worked pretty well, but one thing got broken in the change. The registration page uses a Captcha to help avoid web spam, which has been a problem in the past. However, the code to fetch the relevant html was still getting plain http, and thus browsers were refusing to display the Captcha...
Technical Blog

The rds_superuser role isn't that super

The Amazon RDS documentation blithely contains this statement: “When you create a DB instance, the master user system account that you create is assigned to the rds_superuser role. The rds_superuser role is similar to the PostgreSQL superuser role (customarily named postgres in local instances) but with some restrictions.” But just how super is it? One of the things I came up against recently was...
Technical Blog

Managed Database Services - pros and cons

Using a managed service is a very attractive proposition. You are offloading a heck of a lot of worry, especially when it comes to something as complicated and, let’s face it, specialized as a database. Someone else will set it up for you, and back it up, and keep it running, without you having to worry too much about it. However, there are downsides. You can only get what the manager is offering...