BE SHARING

PostgreSQL

MongoDB: How to translate SQL to MongoDB commands

17.09.2023 by Nabil Saoual

Introduction Hi everybody If you work with databases, you will be familiar with the two main philosophies used in this domain: The SQL philosophy (RDBMS) and, of course, NoSQL databases.Some examples of SQL databases are Oracle and Postgres, while Nosql(…)

Development & Performance

Guide to Install and Use pgFormatter on Linux (openSUSE)

31.08.2023 by Joan Frey

pgFormatter is a command-line tool used to format SQL code for PostgreSQL databases. It helps improve code readability and maintainability by applying consistent indentation and formatting rules to your SQL queries. This guide will walk you through the process of(…)

Database management

Simplifying PostgreSQL Management: A Guide to Install and Use pgcli

18.08.2023 by Joan Frey

Managing databases is a crucial aspect for a DBA, and PostgreSQL is a powerful open-source relational database management system that is widely used. To interact with a PostgreSQL database, DBA and developers often rely on command-line tools. The default tool(…)

Database Administration & Monitoring

Troubleshooting Patroni Cluster: pg_hba Configuration not applied

16.08.2023 by Joan Frey

In the world of database management, high availability and data integrity are of most importance. Patroni, a robust open-source solution, offers a way to manage and maintain PostgreSQL high availability clusters seamlessly. However, even with tools like Patroni, you can(…)

Control-M

Control-M /EM: “Failed installing PostgreSQL database” error message

23.07.2023 by Nabil Saoual

Introduction: During a Control-M installation, you can face some issues, sometime it’s due to a lack of prerequisites ( Keep the best practices and be sure to follow the advice from BMC site experts, take a look on the installation(…)

OMrun

Database Check for a one-to-one Migration with OMrun

29.06.2023 by Oliver Schwark

Procedure to check a one-to-one migration between different database types autogenerated and generically with OMrun.

Ansible

An overview of “Oracle Cloud Infrastructure: everything for an efficient migration” event by dbi services

17.05.2023 by Elisa Usai

Is the Oracle Cloud a hot topic for you? dbi services organized an event about the Cloud today in Lausanne: "Oracle Cloud Infrastructure: everything for an efficient migration".

Database management

Microsoft Flexible Server Compute V5

17.03.2023 by Karsten Lenz

Today I had the chance to move forwar with performance testing and some checks on two Flexible Server – Azure Database for PostgreSQL, one with 8vCPU, 64GB RAM and 512GB Storage (2300 IOPs) and another one with the same vCPU(…)

Database management

Flexible Server for PostgreSQL, Status March 2023

02.03.2023 by Karsten Lenz

As many know about a year ago I wrote some critical posts about Microsofts Flexible Server for PostgreSQL, now it is time to take a look again. At first, many promised functions where delivered with a latency of about one(…)

Database Administration & Monitoring

TimescaleDB

15.02.2023 by Joël Cattin

Introduction TimescaleDB is a “time-series” database (TSDB). This kind of databases are optimized for storing, manipulating and querying time-series data. But… what is time-series data ?Time-series data is a collection of metrics (regular) or measurements (irregular)(…)