PostgreSQL from installation to production: configuration, streaming replication, high availability with Patroni, backups with pgBackRest, performance tuning, extensions, upgrades and migrations from other database engines.
The PostgreSQL Community just made a significant leap forward in database security :Postgresql is now a CVE Numbering Authority (CNA). Here is the original announcement about PostgreSQL being added as a CNA on the CVE website. This move marks a pivotal moment for PostgreSQL administrators and users. The Root CVE for Postgresql is RedHat. This last one has only been…
Last week was the week of the European PostgreSQL Conference in Prague which I was allowed to join once more. An amazing location was waiting for all the participants and once I entered the hotel, I already felt warmly welcomed in the PostgreSQL Community world. Besides the very interesting program the committee prepared this year, there was of course a…
PostgreSQL, an open-source relational database management system, offers robust features and capabilities for data storage and management. Deploying PostgreSQL within the Oracle Cloud Infrastructure (OCI) provides a scalable and reliable environment. In this guide, we’ll explore the process of setting up PostgreSQL in OCI. We will also push a bit more to learn how backup/restore and failover works. Let’s discover…
I know, few years ago, it was uncredible to associate SQL Server & PostgreSQL or see Microsoft in the Open source world. 😉 The world changes and we follow it… My colleague Daniel Westermann will enjoy that I write a blog about PostgreSQL but also SQL Server… My first one in 10 years by dbi services but it’s good to…
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 important in your database to have your access privileges setup right from the get go!In PostgreSQL terms the only difference between a…
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 databases are MongoDB and Redis.How do these two philosophies work?Is it possible to switch from one language system to the…
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 installing and using pgFormatter on a Linux system, specifically openSUSE. I. Installation For this guide, I will install pgFormatter using…
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 that is used is psql. What if I told you that you can simplify the interaction with your database with…
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 face challenges. The setup: Patroni Cluster Installation I had the mission of setting up a Patroni cluster for a critical…
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 documentation to fill all the prerequisite). However it can be a singular issue ( not as explicit as a right…
Procedure to check a one-to-one migration between different database types autogenerated and generically with OMrun.
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“. After a welcome coffee to meet each other, Pascal Zanette shortly introduced the event and the agenda of the day. Our CTO Hervé Schweitzer presented then YaK, developed by dbi services.The idea…
