All articles

PostgreSQL 12: New option –exclude-database for pg_dumpall

By Mouhamadou Diaw Up to PostgreSQL 11 pg_dump all was used to dump all PostgreSQL databases of a cluster into one script file. The script file then contains SQL commands that can be used as input to psql to restore(…)

How to disable ACLs in Oracle 12c

A common problem in Oracle 12c is, that ACLs are often not wanted to limit connections from database to other hosts. To disable ACLs is not that easy, so the best way is to enable connections and resolutions to all(…)

How workload policies is making your life easy

Working as a control-M administrator, we are often requested to hold jobs or stop jobs during a period of time. Holding jobs and updating the job configuration might not be the most efficient way to do this. Workload policies is(…)

Documentum – Documents not transferred to WebConsumer

Receiving an incident is not always a pleasure, but it is always the case when we share the solution! A few days ago, I received an incident regarding WebConsumer on a production environment, saying that documents are not transferred as(…)

MySQL 8 and Security – Encryption of binary logs

As I discussed in some of my recent talks at conferences (at the DOAG for example), MySQL 8 came out with new features which bring lots of improvements in terms of security.

Working with files on the filesystem in PostgreSQL

PostgreSQL comes with various helper functions that support you with working with files on the filesystem on the host PostgreSQL is running on. You might ask yourself why that is important but there are use cases for that. Maybe you(…)

Create a primary database using the backup of a standby database on 12cR2

The scope of this blog will be to show how to create a primary role database based on a backup of a standby database on 12cR2. Step1: We are assuming that an auxiliary instance has been created and started in(…)

Documentum – MigrationUtil – 3 – Change Server Config Name

In the previous blog I changed the Docbase Name to repository1 instead of RepoTemplate using MigrationUtil, in this blog it is Server Config Name's turn to be changed.

PostgreSQL : barman rsync method vs streaming method

By Mouhamadou Diaw Barman is a tool to perform backup and recovery for PostgreSQL databases. It can do backup using two methods: -rsync/ssh -streaming In this blog I am going to explain how to use these two(…)

New search function for Oracle database features

Oracle released a new way to search for database features, and it is ...