PostgreSQL

Introduction to PostgreSQL in OpenShift

I’m on a mission to tackle scary topics around DevOps these days! In my 2 previous blog posts (Part 1 and Part 2) I’ve tried to demystified the DevOps word (and(…)

PostgreSQL Backups with pg_back

1. Introduction In the world of PostgreSQL database management, ensuring robust backup strategies is mandatory. This week I discovered on postgresql.org latest news one useful tool that streamlines this process: pg_back. pg_back serves as a dedicated dumping(…)

PostgreSQL’s New Milestone in Security: Officially CVE Numbering Authority

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

And suddenly it’s already over again – pgconf.eu 2023

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

New PostgreSQL service in OCI

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

PosgreSQL + SQL Server = WiltonDB – Part 1 – Installation

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

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

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

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