PostgreSQL

PostgreSQL: Dropping a table automatically if another table is dropped

Imagine the following use case: You have a table t1, and based on it’s contents you create another table t2. What you want to achieve is: If table t1 gets dropped, you want to have table t2 to be dropped(…)

2022.pgconf.eu Berlin conference for tech

Last week, the biggest European PostgreSQL event of the year took place in Berlin (2022.pgconf.eu). This event is an excellent opportunity to meet developers from the PostgreSQL community and to attend high profile tech presentations. Tuesday evening we started(…)

2022.pgconf.eu, what a blast

2022.pgconf.eu is currently happening in Berlin. We have a record number of 600 attendees, this makes it the largest ever PostgreSQL Conference Europe and we’re hitting the hard limits of the venue.

Helvetia used AWS SCT & DMS to migrate to AWS RDS for PostgreSQL

One of our long term-time customers, Helvetia, successfully migrated on-prem Oracle databases to AWS, not only because of the licenses, but more importantly: to deploy faster, innovate faster, and use the state-of-the-art open source(…)

PostgreSQL 15: Some new features

PostgreSQL version 15 is on its way and we get a better and better look, what will be included in the future release. So it's time to have a look at some new future features(…)

PostgreSQL 15: More flexibility with setting parameters

Another nice feature just made it into PostgreSQL 15: You can now control who is allowed to set specific parameters. This gives you a lot more flexibility, especially when you are hosting PostgreSQL instances for your customers. You can delegate(…)

PostgreSQL client only installations from source code

During our PostgreSQL DBA Essentials workshops we install PostgreSQL from source code. We do that, to provide the participants all the options they have. There is nothing wrong with using a packaged distribution of PostgreSQL, don't get(…)

PostgreSQL 15: Add row filters for logical replication

My last post about logical replication in PostgreSQL was in 2017 before PostgreSQL 10 was released later that year. There have been many enhancements to logical replication since then and today we'll look at a new features(…)

PostgreSQL 15: New option for NULL handling in unique constraints

Another nice feature was just committed for PostgreSQL 15: Add UNIQUE null treatment option (discussion here, commit details here). What is it about? The answer is quite easy if we do a little example(…)

PostgreSQL 15: New function to list flags associated to GUCs

As development of PostgreSQL 15 is on its way, more and more features get committed. Today we'll look at a new feature which is not a hammer feature, but a nice thing to have and to know about. If you(…)