Infrastructure at your Service

Mouhamadou Diaw

Backup and Restore PostgreSQL with PgBackRest I

By | Database Administration & Monitoring | No Comments
 

 Many tools can be used to backup PostgreSQL databases. In this blog I will talk about PgBackRest which is a simple tool that can be used to backup and restore a PostgreSQL database. Full, differential, and incremental backups are supported. In this first blog I will present a basic configuration of pgbackprest. Our configuration is composed of only one cluster and pgbackrest is installed on the server hosting the database. The goal is to explain…

Read More
David Barbarin

SQL Server on Docker and network bridge considerations

By | Database Administration & Monitoring | No Comments
 

 Let’s continue with this blog post series about SQL Server and Docker. A couple of days ago, I was in a customer shop that already implemented SQL Server 2017 on Linux as Docker containers. It was definitely a very interesting day with a lot of customer experience and feedbacks. We discussed with him about lot of architecture scenarios. The interesting point here is I was able to compare with a previous customer who used docker…

Read More
Grégory Steulet

Can you trust option_packs_usage_statistics.sql ?

By | Database Administration & Monitoring | One Comment
 

 Introduction As a former Oracle LMS qualified auditor my opinion is sometimes requested before/during/after an Oracle LMS audit or simply to ensure a customer that his Oracle database is 100% in conformity with Oracle Licensing Policy. Even if “The Oracle License Management Services (LMS) Group is the only Oracle group authorized to review and provide opinions on compliance status and will provide guidance, education and impartial opinions on a customer or partner’s compliance state. For…

Read More
Daniel Westermann

How we build our customized PostgreSQL Docker image

By | Database Administration & Monitoring | No Comments
 

 Docker becomes more and more popular these days and a lot of companies start to really use it. At one project we decided to build our own customized Docker image instead of using the official PostgreSQL one. The main reason for that is that we wanted to compile from source so that we only get want is really required. Why having PostgreSQL compiled with tcl support when nobody will ever use that? Here is how…

Read More
Grégory Steulet

La Suisse concernée par le RGPD ?

By | Database Administration & Monitoring | No Comments
 

 Le 25 mai 2018 entretra en application le Règlement Général sur la Protection des Données (RGPD). Il impactera toutes les entreprises opérant du traitement de données à caractère personnel sur des résidents européens. A l’aube de cette échéance, beaucoup de fausses informations circulent au sein des entreprises suisse. L’objectif de ce blog est d’apporter quelque lumière sur les questions qui se posent. Pour ce faire, nous avons demandé à Me Metille, avocat spécialisé en protection…

Read More
David Barbarin

Index seek operator and residual IO

By | Database Administration & Monitoring | No Comments
 

 This blog post draws on the previous article about index seek and gotchas. I encountered another interesting case but it is not so much because of the nature of the problem I decided to write this article but rather the different ways that exist to troubleshoot it. Firstly, let’s set the scene: A simple update query and its corresponding execution plan that tend to say the plan is efficient  in terms of performance declare @P0…

Read More
Morgan Patou

Windows Server – Service not starting with ‘Error 1067: The process terminated unexpectedly’

By | Application integration & Middleware, Entreprise content management | No Comments
 

 Some time ago, we were installing a Migration Center (from fmeAG) on a Windows Server and at the end of the installation, the service named Migration Center Job Server is configured and finally started. Unfortunately this didn’t go well and the start command wasn’t working at all. We were using a dedicated technical account (AD account) to do the installation and to run this service. This is the error we got:   The error code…

Read More
Morgan Patou

Documentum – DA 7.3 showing java.lang.NullPointerException on every actions

By | Application integration & Middleware, Entreprise content management | No Comments
 

 Last year, we started to upgrade some Documentum Administrator from 7.2 to 7.3 and directly after, we started to see some NullPointerException on the log files. We are using DA 7.3 on some recent WebLogic Servers versions (12.1.3, 12.2.1.2). We usually deploy DA as a WAR file (so not exploded) with just the dfc.properties, keystores and logs outside of it. This is the kind of errors we started to see as soon as it was…

Read More
Morgan Patou

WebLogic – SSO/Atn/Atz – Infinite loop

By | Application integration & Middleware, Entreprise content management | No Comments
 

 This blog will be the last of my series around the WebLogic SSO (how to enable logs, 403 N°1, 403 N°2) which I started some weeks ago. Several months ago on a newly built High Availability Environment (2 WebLogic Servers behind a Load Balancer), an application team was deploying their D2 Client as always. After the deployment, it appeared to the tester that the Single Sign-On was not working when using the SSO URL through…

Read More
Franck Pachot

Server process name in Postgres and Oracle

By | Oracle, Postgres | No Comments
 

 Every database analysis should start with system load analysis. If the host is in CPU starvation, then looking at other statistics can be pointless. With ‘top’ on Linux, or equivalent such as process explorer on Windows, you see the process (and threads). If the name of the process is meaningful, you already have a clue about the active sessions. Postgres goes further by showing the operation (which SQL command), the state (running or waiting), and…

Read More
Franck Pachot

12cR2 PDB archive

By | Oracle | No Comments
 

 In 12.1 we had the possibility to unplug a PDB by closing it and generating a .xml file that describes the PDB metadata required to plug the datafiles into another CDB. In 12.2 we got an additional possibility to have this .xml file zipped together with the datafiles, for an easy transport. But that was not working for ASM files. The latest Release Update, Oct 17 includes the patch that fixes this issue and is…

Read More