PostgreSQL

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

Postgres, the fsync() issue, and ‘pgio’ (the SLOB method for PostgreSQL)

By Franck Pachot . That's a long blog post title, which is actually just a good pretext to play with Kevin Closson SLOB method for PostgreSQL: pgio I use the beta version of pgio here. If you want to read(…)

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 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.

Setting up MiniShift

Currently we have many requests to support customers in running PostgreSQL in Docker containers. Some of those use redhat OpenShift as the management platform for their Docker deployments. Setting up an OpenShift cluster requires quite some resources and(…)

Can I do it with PostgreSQL? – 19 – Create user … identified by values

Puh, that last post in this series is already half a year old. Time is moving too fast :( Today, while being at a customer again, this question came up: Can I do something comparable in PostgreSQL(…)