Daniel Westermann

Getting started with Exasol – Setting up an environment

Exasol is an in memory database with parallel processing, or shorter MPP(Massively Parallel Processing) database. I got in touch with some people from Exasol at the DOAG 2019(…)

PostgreSQL 13: Trusted extensions

PostgreSQL 13 is just around the corner and one little, but important feature that was added are trusted extensions. When you want to add an extension to a database you need to be superuser for most of the extension or(…)

Using PostgreSQL’s adminpack extension to write files

In PostgreSQL you have several ways of working with files and you can find quite some examples here on our blog, e.g. Modifying pg_hba.conf from inside PostgreSQL, Can I do it with(…)

The EDB tool-set integration into PEM – EDB EFM

In the last post we had a look at how EDB BART integrates into EDB PEM, so backups and restores can be managed centrally from the PEM console.

The EDB tool-set integration into PEM – EDB BART

When it comes to our PostgreSQL customers we basically have two types: There are customers that do not want to have a subscription. For these types of customers we go with plain community PostgreSQL and a(…)

Attaching your own CentOS 7 yum repository to AWS SSM

From some blogs I've written in the past you might already know that we are using AWS SSM to patch and maintain the complete EC2 and onprem instances at one of our customers. The previous posts(…)

Publishing a PowerShell script to AWS Lambda

I've done some Lambda functions with Python in the past and it was quite easy to publish that to Lambda (by just uploading a zip file with all my code and dependencies). You might ask yourself(…)

AWS RDS for PostgreSQL – 4 – Changing parameters

If you followed that last posts about DB Parameter Groups, Subnet Groups and Setting up the RDS instance you should have a running RDS instance. You should also(…)

AWS RDS for PostgreSQL – 3 – Creating the RDS PostgreSQL instance

In the last tow posts we had a look at DB Parameter Groups and Subnet Groups as these need to be ready when you want to deploy a RDS PostgreSQL instance on(…)

PostgreSQL 13: Backup validation and backup manifests

Currently a lot of stuff is being committed for PostgreSQL and what we will look at in this post is a feature, I am sure, a lot of PostgreSQL users have been waiting for for a long time: Finally there(…)