Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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 all fully understand your decision and the reasons to move on to a new challenge, this post is dedicated to you and you need to be the example in the following little demo. Lets go …  

 
Read More
Michael Hein

Disabling database trap with dataguard broker

By | Database Administration & Monitoring | No Comments

When connecting to dataguard broker and disabling database with ORACLE_SID set before connecting to broker, broker becomes inaccessible, which is shown below: Login to broker via database ila: oracle [ILA@p03] /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs : dgmgrl / DGMGRL for Linux: Version 11.2.0.4.0 – 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to DGMGRL, type “help” for information. Connected. DGMGRL> show configuration; Configuration – ila Protection Mode: MaxAvailability Databases: ILAP – Primary database ila – Physical…

 
Read More
David Barbarin

Dealing with ugrade scenarios for SQL Server on Docker and Swarm

By | Database Administration & Monitoring | No Comments

This blog post comes from an interesting experience with one customer about upgrading SQL Server on a Docker environment. Let’s set quickly the context: a production environment that includes a standalone Docker engine on the top of openSUSE Linux distribution with some SQL Server 2017 Linux containers. The deal was to update those SQL Server instances from 2017 CU1 to 2017 CU7. The point is we applied the same kind of upgrades earlier on the morning but it…

 
Read More
Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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 this post we’ll look at how you can do it at least for testing. For production it is of course not recommended as hacking the make file is nothing you want to do, at least I would not…

 
Read More
Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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 when you add a column to table which has a non null default value the whole table needed to be rewritten. With PostgreSQL 11 this is not anymore the case and adding a column in such a way…

 
Read More
Michael Hein

How to flashback databases in dataguard with broker

By | Database Administration & Monitoring | No Comments

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 ilal – Logical standby database ILAP – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS How to set restore points here ? Two things to consider: Redo apply to a physical standby is incompatible with setting a restore point…

 
Read More
Mouhamadou Diaw

PostgreSQL 11 : Procedures are coming

By | Database Administration & Monitoring | No Comments

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 returns a value, we can say, yes it’s true but you cannot manage transactions in a function. To better understand let’s do a quick demonstration. Note that I am using the snapshot developer version of PostgreSQL 11 ….

 
Read More
Franck Pachot

Installing MAMP to play with PHP, MySQL and OpenFlights

By | Database Administration & Monitoring, Oracle | No Comments

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 students at https://powercoders.org/, a coding academy for refugees in Switzerland. They install MAMP (My Apache – MySQL – PHP) during their curriculum for website development, and then I’ll use this environment to teach data modeling and SQL basics. Thus,…

 
Read More
Jérôme Dubar

Patching ODA lite to 12.2.1.3.0

By | Database Administration & Monitoring | No Comments

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 release and here is how to do that. In this example I was patching from 12.1.2.12.0, no intermediate patch was needed. 1) Download the patch It seems odd but sometimes finding the corresponding patch is…

 
Read More
David Barbarin

Introducing SQL Server on Kubernetes

By | Database Administration & Monitoring | No Comments

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 of the most popular orchestration tools in the IT industry. By the way, I like to refer to the Portworx Annual Container Adoption Survey to get a picture of container trend over the years and we…

 
Read More