All articles

Increase your PostgreSQL databases security by checking a few settings Part 2

Continuing from my first blog we will check some more access and authentication configurations. Focusing on removing unnecessary database privileges. After that we will configure the backend parameters correctly to have more robust PostgreSQL server/client sessions. And at last SSL(…)

PostgreSQL 13 and Patroni 2.0 – when parameters change

Starting with PostgreSQL 13 there is a name and value change of one of the parameters used for the streaming replication of a replica server. Some may already know which parameter I am talking about. Until Postgres 12 it was(…)

Oracle 20c Data Guard : Standardization of Client-Side Broker Files

By Mouhamadou Diaw In an Oracle 20c Data Guard environment with a broker configured we can have following files called client-side broker files -The observer configuration file : observer.ora -The observer log file -The observer runtime datafile:(…)

Patroni 2.0: New features – Patroni on pure Raft

Last week the new Patroni 2.0 release was published which brings many new features. But one makes me absolutely curious. At the moment only as BETA, but I had to test it. Patroni on pure Raft. It's possible to run(…)

Starting with PostgreSQL

In this Post you will learn how I met PostgreSQL and started to learn. If you are planning PostgreSQL as your database but don’t know where to start, this blog may help you. My background I have used MySQL database(…)

Installing MariaDB Columnstore 1.5 on CentOS 8

In my previous blog, I talked about how to install the latest MariaDB Community Server 10.5.5 on CentOS 8 but now I will talk about the latest version of MariaDB ColumnStore 1.5 which is not anymore a separate fork of(…)

Build API backend server with NodeJS and PostgreSQL

Introduction In this Blog I will describe how to create an API Backend with NodeJS using PostgreSQL as Database. We will create API for public events with CRUD options. CRUD means: create, read, update and delete. Firstly, we will create(…)

Oracle REST Data Services – Create Web Services

In my previous blog Oracle REST Data Services – Installation and Configuration : We have installed ORDS in standalone mode. Configured ORDS to be administer by SQL Developer In this blog, we will explain how to create simple RESTful(…)

Oracle REST Data Services – Installation and Configuration

The goal of this blog is to install and configure Oracle REST Data Services 19.2 in Standalone mode into an oracle database 12.2. The official documentation is stored here and you will find a lot of resources and examples(…)

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