Infrastructure at your Service

All Posts By

Daniel Westermann

Daniel Westermann

Can there be orphaned data files in PostgreSQL?

By | Database Administration & Monitoring | No Comments

PostgreSQL, as all other relational database systems, needs to persist data on disk, either by writing the writing the write ahead log or by synchronization the data files on disk whenever there is a checkpoint. When it comes to the data files PostgreSQL creates a new one once a relation reaches segment_site, which is 1GB by default. Because of this a relation can consist of many files if the relation is growing. The question I…

Read More
Daniel Westermann

PostgreSQL 13 will allow to drop databases even when there are connections

By | Database Administration & Monitoring | No Comments

One of the most popular blogs I’ve written about PostgreSQL was about the three databases that PostgreSQL creates by default (well, actually it is initdb that creates the databases). One of the points mentioned in that post was, that you can not drop a database as long as there are sessions against the database you want to drop. This will change with PostgreSQL 13, which is currently in development.

Read More
Daniel Westermann

A simple Terraform script to create an AWS EC2 playground

By | Cloud, Database Administration & Monitoring | No Comments

When I started to write the blog about AWS SSM I quickly realized that I need a way to bring up and destroy my AWS EC2 playground in an easy and reproducible way. There are several options for this: I could have used the AWS command line interface or AWS CloudFormation. Both work pretty well and would have been more than enough for my simple requirements. In the end I decided to use Terraform for…

Read More
Daniel Westermann

Avoiding patching madness by using AWS SSM

By | Cloud, Database Administration & Monitoring | No Comments

As we have more and more customers either currently moving to AWS or already moved much, if not even all, of their workloads to AWS, one question pops up quite frequently: Now that we have so many EC2 instances up and running how do we regularly patch them? There are many tools around for patching operating systems, such as Microsoft SSCM, Red Hat Satellite or SUSE Manager just to name a few. There are many…

Read More
Daniel Westermann

pg_auto_failover: Setup and installation

By | Database Administration & Monitoring | No Comments

When I attended PGIBZ 2019 earlier this year, I talked with Dimitri about pg_auto_failover and I promised to have a look at it. Well, almost half a year later and after we’ve met again at pgconf.eu it is time to actually do that. You probably already know that citudata was acquired by Microsoft earlier this year and that Microsoft seems to be committed to open source since a few years. pg_auto_failover is one of the…

Read More
Daniel Westermann

PostgreSQL 13 will come with partitioning support for pgbench

By | Database Administration & Monitoring | No Comments

A lot of people use pgbench to benchmark a PostgreSQL instance and pgbench is also heavily used by the PostgreSQL developers. While declarative partitioning was introduced in PostgreSQL 10 there was no support for that in pgbench, even in the current version, which is PostgreSQL 12. With PostgreSQL 13, which is currently in development, this will change and pgbench will be able to create a partitioned pgbench_accounts tables you then can run your benchmark against.

Read More
Daniel Westermann

Where can you find core developers asking people what is missing in PostgreSQL? pgconf.eu.2019

By | Database Administration & Monitoring | No Comments

One of the major advantages of PostgreSQL conferences when you compare it to other conferences is, that you can listen to talks where the actual developers are presenting their work. You have questions about a feature, you want to know more about this or that: Just catch one of the developers and start to talk. It is as easy as that. Today it was even more impressive: Alvaro came to our booth and asked what…

Read More
Daniel Westermann

Creating a customized PostgreSQL container using buildah

By | Database Administration & Monitoring | No Comments

Quite some time ago I blogged about how you could build your customzized PostgreSQL container by using a Dockerfile and Docker build. In the meantime Red Hat replaced Docker in OpenShift and SUSE replaced Docker as well in CaaS. As a consequence there need to be other ways of building containers and one of them is buildah. You can use buildah to build from a Docker file as well, but in this post we will…

Read More