Database Administration & Monitoring

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

How to flashback databases in dataguard with broker

Last week I had to do some tests with dataguard. To make restores easier restore points were required. Given is following configuration: show configuration; Configuration - ila Protection Mode: MaxAvailability Databases: ila - Primary database(…)

PostgreSQL 11 : Procedures are coming

By Mouhamadou Diaw Reading about new features about future version PostgreSQL 11. I see that procedures will be implemented. Why is it so important? Until now only functions are available in PostgtreSQL. Of course a function is a procedure that(…)

Installing MAMP to play with PHP, MySQL and OpenFlights

By Franck Pachot . You may wonder what I'm doing with those technologies that are completely different from what I usually do. I'll detail in a future blog post but the idea is giving a short introduction to databases to(…)

Patching ODA lite to 12.2.1.3.0

Here is the latest patch for your ODA and it seems that Oracle documentation for this patch is not exactly the procedure you’ll have to follow to successfully patch your appliance. I recently updated X6-2M and X6-2L to this latest(…)

Introducing SQL Server on Kubernetes

After spending some times with Docker Swarm let’s introduce SQL Server on Kubernetes (aka K8s). Why another container orchestrator? Well, because Microsoft gives a strong focus on Kubernetes in their documentation and their events and because K8s is probably one(…)

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

SQL Saturday Paris 2018 – Pré-conférence SQL Server Linux, Docker et Azure

The next SQL Saturday in Paris is coming soon and the agenda has been published by the @GUSS on twitter. Le prochain SQL Saturday Paris arrive bientôt et l’agenda a été publié sur Twitter par le(…)

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