BE SHARING

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

Database Administration & Monitoring

SQL Server Tools: First steps with go-sqlcmd tool on Windows Server 2022

11.08.2023 by Stéphane Haby

As you know, with the new version of SSMS since the version 18, the tools like sqlcmd are no more included in the installation. You need to download separately the tools that you need here Few months ago, Microsoft(…)

Ansible

OCI: Automate your Oracle Cloud Database software releases deployment (db-home)

07.08.2023 by Jérôme Witt

As part of a very exciting project around Oracle Exadata Cloud @ Customer (aka. ExaCC) technology, we wanted to rollout in an automated manner the database software aka. ORACLE_HOME on ExaCC database clusters (aka. VM cluster). However, we rapidly identified(…)

Database Administration & Monitoring

PostgreSQL 16: Playing with pg_stat_io (1) – extends

28.07.2023 by Daniel Westermann

PostgreSQL 16 (currently in beta 2) will come with a new view for tracking I/O related statistics. I’ve written a very basic blog about pg_stat_io in the past. In this post and(…)

Database Administration & Monitoring

Generated columns in PostgreSQL

27.07.2023 by Daniel Westermann

Sometimes it becomes handy when you can auto-generate a column based on an expression. For this there is the concept of generated column. Those columns can be either of type “stored” (the derived value is computed when the column is(…)

Database Administration & Monitoring

PostgreSQL: System catalog modifications are currently disallowed

12.07.2023 by Daniel Westermann

Today at a customer I faced this: “System catalog modifications are currently disallowed” which, honestly, I’ve never seen before. Why would someone try to modify the system catalogs, at least in a productive environment? It turned out to be pretty(…)

Database management

SQL Server Tips: CMS – Connection Error: -2146893019 Severity: 20

05.07.2023 by Stéphane Haby

Few days ago, I install new instances SQL Server 2022 and the new SSMS by a customer and when I register the instances in the Central Management Servers (CMS), I was surprise by the error coming from the connection test:(…)

Database Administration & Monitoring

PostgreSQL 16: More statistics in pg_stat_*_tables

05.06.2023 by Daniel Westermann

PostgreSQL 16 is already in feature freeze and Beta1 has been released on May 25th. This is the time you should start testing and report any issues back to the community. There are plenty of new features, as usual, and(…)

Database Administration & Monitoring

2023.pgconf.de and the Swiss PGDay are just around the corner

02.06.2023 by Daniel Westermann

Time flies, we are in June already and at the end of this month two PostgreSQL conferences will take place: There is 2023.pgconf.de, this year in Essen, the 27th of June. For the first time in(…)