Database Administration & Monitoring

Increase your PostgreSQL databases security by checking a few settings

This blog provides you with a short overview of easy to control settings that enhance your PostgreSQL security. Mostly by creating a separate group to assign privileged database members. And checking different logging and log rotations settings for better and(…)

Configure PostgreSQL to allow remote connection

By default, PostgreSQL will only allow localhost connection. If you want allow remote connections, you need to configure it. Configuring postgresql.conf First we need to find out where our conf file is located. You have two options: If you(…)

How to create an AWS EC2 Auto Scaling Group

AWS comes with the great service of auto scaling, that gives the possibility to automatically adapt the environment to the changing needs. This helps to optimize costs and performance. With rising needs, your environment scales up and as soon as(…)

Reimaging an ODA to 19.8 Part II

By Mouhamadou Diaw In my previous blog, I described the steps to deploy an ODA 19.8 by reimaging. The ODA was reimaged with the latest available version 19.8 but some components were not up-to-dated. 1(…)

Reimaging an ODA to 19.8 Part I

By Mouhamadou Diaw Recently I was deploying some ODA X8-2M. To install the 19.8 software, I decide to reimage the server with the 19.8 image. In this blog I describe the main steps I did. First, we will need to(…)

Boost your CPU speed with Standard Edition 2 on ODA

Introduction There is no need to decrease the number of cores on your ODA when using Standard Edition 2, because your license is based on the number of physical CPU. So why would you do that? Obviously, the more cores(…)

Control-M/EM Order jobs with a specific user daily

Introduction Hi everybody,today let’s see an easy way to order a folder at a specific hour/date instead of being ordered directly by the new day procedure. To do so, we will use the ctmudly utility. Ctmudly command To(…)

The EDB tool-set integration into PEM – EDB EFM

In the last post we had a look at how EDB BART integrates into EDB PEM, so backups and restores can be managed centrally from the PEM console.

The EDB tool-set integration into PEM – EDB BART

When it comes to our PostgreSQL customers we basically have two types: There are customers that do not want to have a subscription. For these types of customers we go with plain community PostgreSQL and a(…)

Oracle Data Pump Integration for Table instantiation with Oracle Golden Gate

From Oracle GoldenGate (OGG) version 12.2 and above, there is a transparent integration of OGG with Oracle Data Pump as explained in the Document ID 1276058.1. The CSN for each table is captured on an Oracle Data Pump export. The(…)