PostgreSQL

PostgreSQL: Managing multiple “users” with roles

Having multiple users but don’t want them to use the same account?In such a case you can use a role to group your users together.And even better you can set default privileges for that role before creating anything(…)

MongoDB: How to translate SQL to MongoDB commands

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

Guide to Install and Use pgFormatter on Linux (openSUSE)

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

Simplifying PostgreSQL Management: A Guide to Install and Use pgcli

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

Troubleshooting Patroni Cluster: pg_hba Configuration not applied

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 /EM: “Failed installing PostgreSQL database” error message

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

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

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

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

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".

Microsoft Flexible Server Compute V5

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

Flexible Server for PostgreSQL, Status March 2023

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