Daniel Westermann

Is adding a column to a typed table in PostgreSQL instant?

Today at the SOUG Day I did some little demos and one of them was about creating typed tables. In the demo the two tables did not contain any rows and one of the(…)

Do you need the same column with the same check constraint twice? Create a domain!

Did you know that you can create domains in PostgreSQL? No, nothing to worry about. We'll take Frank's leave for a new opportunity as a chance to introduce the concept of domains. @Franck: Yes, although we(…)

How to compile PostgreSQL 11 with support for JIT compilation on RHEL/CentOS 7

As you might already know PostgreSQL 11 will bring support for just-in-time compilation. When you want to compile PostgreSQL 11 with jit support on RedHat/CentOS 7 this requires a little hack (more on the reason below). In(…)

PostgreSQL 11: Instant add column with a non null default value

As I am currently preparing my session for the Swiss PGDay which is about some of the new features for PostgreSQL 11, I though this one is worth a blog post as well. Up to PostgreSQL 10(…)

EDB Failover Manager in EDB containers in Minishift/OpenShift – Failovers

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. In the last post we had a look at the basic configuration of EDB EFM and confirmed that(…)

EDB Failover Manager in EDB containers in Minishift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. In the last three posts we deployed an EDB database container and two pgpool instances,(…)

Customizing PostgreSQL parameters in EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. In the last two posts we deployed an EDB database container and two pgpool instances and then(…)

Scaling the EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. When you followed the last post you should have two pgpool instances and one EDB Postgres instance running(…)

Deploying EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. In this post we'll look at how we can deploy EnterpriseDB containers in MiniShift. When you need to(…)

Deploying PostgreSQL in MiniShift/OpenShift

The last post quickly outlined on how you can setup MiniShift for playing around with OpenShift on your workstation. In this post we'll setup PostgreSQL in MiniShift using the default PostgreSQL image that already comes with MiniShift.