Infrastructure at your Service

All Posts By

Daniel Westermann

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
Daniel Westermann

EDB EPAS 12 comes with interval partitioning

By | Database Administration & Monitoring | No Comments

While community PostgreSQL 12 is in beta quite some time now (currently in beta 3) it usually takes some time until EDB EPAS will be available on top of the next major PostgreSQL release. Yesterday EDB finally released a beta and you can register for access here, release notes here. One of the new features is interval partitioning which you already might know from Oracle. Basically you do not need to create range partitions in…

Read More
Daniel Westermann

Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption

By | Database Administration & Monitoring | No Comments

From time to time you might require to reboot your AWS instances. Maye you applied some patches or for whatever reason. Rebooting an AWS instance can be done in several ways: You can of course do that directly from the AWS console. You can use the AWS command line utilities as well. If you want to schedule a reboot you can either do that using CloudWatch or you can use SSM Maintenance Windows for that….

Read More
Daniel Westermann

Migrating your users from md5 to scram authentication in PostgreSQL

By | Database Administration & Monitoring | One Comment

One of the new features in PostgreSQL 10 was the introduction of stronger password authentication based on SCRAM-SHA-256. How can you migrate your existing users that currently use md5 authentication to the new method without any interruption? Actually that is quite easy, as you will see in a few moments, but there is one important point to consider: Not every client/driver does already support SCRAM-SHA-256 authentication so you need to check that before. Here is…

Read More
Daniel Westermann

Converting columns from one data type to another in PostgreSQL

By | Database Administration & Monitoring | No Comments

Usually you should use the data type that best fits the representation of your data in a relational database. But how many times did you see applications that store dates or numbers as text or dates as integers? This is not so uncommon as you might think and fixing that could be quite a challenge as you need to cast from one data type to another when you want to change the data type used…

Read More