Daniel Westermann

AWS RDS for PostgreSQL – 2 – Subnet groups

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(…)

AWS RDS for PostgreSQL – 1 – DB Parameter Groups

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(…)

Some thoughts about working with/on AWS

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(…)

Where does PostgreSQL store information about default privileges?

A recent comment on the blog post about PostgreSQL default privileges is the reason for this little post: "I’d love to know where postgres stores default privileges?". Well, all the information about privileges should be stored(…)

Rapid PostgreSQL cloning using AWS EBS snapshots

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(…)

PostgreSQL 13 – Autovacuum can now be triggered based on inserts

A common issue with insert only tables in PostgreSQL is, that autovacuum well never kick in as the formula for autovacuum considers obsoleted tuples since the last vacuum but not the number of inserted tuples. Because of this you usually(…)

Using AWS Storage Gateway as a backup target for PostgreSQL – Cached volume gateway

In the last post we had a look on how you can use AWS Storage Gateway as File gateway to store your PostgreSQL backups safely offsite on AWS(…)

Using AWS Storage Gateway as a backup target for PostgreSQL

In the last post we had a quick look at AWS Kinesis data streams and how you can push data to AWS S3 using(…)

Sending PostgreSQL data to AWS S3 by using AWS Kinesis data streams

Before we really start with this post: This is just an experiment and you should not implement it like this in real life. The goal of this post is just to show what is possible and I am not saying(…)

PostgreSQL message levels

When you start to write business logic in the database by using triggers or functions/procedures you usually want to report messages to the user that runs your code or you want to include some debugging output for your own. In(…)