Infrastructure at your Service

All Posts By

Daniel Westermann

Daniel Westermann

Attaching your own CentOS 7 yum repository to AWS SSM

By | AWS, Database Administration & Monitoring | No Comments

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 about that topic are here: Avoiding patching madness by using AWS SSM Avoiding patching madness by using AWS SSM A simple Terraform script to create an AWS EC2 playground Schedule reboots of your AWS instances and how that can…

Read More
Daniel Westermann

Publishing a PowerShell script to AWS Lambda

By | AWS | No Comments

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 why I want to do that with PowerShell but the reason is quite simple: There was a requirement at a customer to automatically collect all the KBs that are installed in the AWS Windows WorkSpaces for compliance reasons. Doing…

Read More
Daniel Westermann

AWS RDS for PostgreSQL – 4 – Changing parameters

By | AWS, Database Administration & Monitoring | No Comments

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 be aware that changing parameters can not be done like you usually do it but you need to do that by changing the DB parameter groups. In this post we’ll look at how you can do that and, especially, what you should avoid.

Read More
Daniel Westermann

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

By | AWS, Database Administration & Monitoring | No Comments

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 AWS. In this post we’ll use these two building blocks to bring up a high available PostgreSQL instance using a master instance in one, and a replica in another availability zone. This is usually what you want when you want a production deployment…

Read More
Daniel Westermann

PostgreSQL 13: Backup validation and backup manifests

By | Database Administration & Monitoring | No Comments

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 is a native way to validate your base backups: pg_validatebackup. This is a new binary that can be used to validate base backups against a backup manifest, that is written automatically when you do backup…

Read More
Daniel Westermann

AWS RDS for PostgreSQL – 2 – Subnet groups

By | AWS, Database Administration & Monitoring | No Comments

In the last post we had a look at DB Parameter Groups when it comes to AWS RDS for PostgreSQL. This is one of the first things you should think about. But even before you think about PostgreSQL parameters you need to configure the networks your database instances shall be running in. In real life this is done by one of your network administrators and you will not have much to configure in this area….

Read More
Daniel Westermann

AWS RDS for PostgreSQL – 1 – DB Parameter Groups

By | AWS, Database Administration & Monitoring | No Comments

When your go for AWS RDS you can very quickly bring up a database instance and start using it. I’ve written about my thoughts using this approach here and really encourage you to learn about a specific service in more detail before you start using it. If you want to have a managed service for PostgreSQL in AWS, you can go for AWS RDS for PostgreSQL and this service will be the topic for this…

Read More
Daniel Westermann

Some thoughts about working with/on AWS

By | AWS, Database Administration & Monitoring | One Comment

In the last year working with/on AWS has become an almost daily task in my life as a consultant and trainer. From a trainer perspective there is not much to say about it because we use a very limited amount of services (EC2, mostly) and we have a limited amount of trainers that use the platform to deliver our trainings. When the amount of services you use is small and the amount of people managing…

Read More
Daniel Westermann

Rapid PostgreSQL cloning using AWS EBS snapshots

By | AWS, Cloud, Database Administration & Monitoring | No Comments

When you go for AWS EC2 instances to host your PostgreSQL deployments and you want to rapidly clone PostgreSQL instances for development or testing purposes you can make use of AWS EBS snapshots. In this post we’ll look at how you can quickly spin up EC2 instances that use these snapshots as a base for new PostgreSQL clusters. Although we’ll be using the AWS console to show how this can be done you should use…

Read More