BE SHARING

Database Administration & Monitoring

Things you can, but probably shouldn’t do in PostgreSQL: Tables in tables, types in types, and arrays on top

20.09.2023 by Daniel Westermann

PostgreSQL comes with a lot of flexibility for defining new data types, defining tables and defining arrays over data types. You can make that as complex as you want, which does not mean that you should do it. Somehow you(…)

No more snapshot too old in PostgreSQL 17

08.09.2023 by Daniel Westermann

Currently PostgreSQL has a feature which is called snapshot too old. While each release of PostgreSQL comes with a bunch of new features, sometimes features also get removed. Starting with PostgreSQL 17 there will be most likely no more “snapshot(…)

Database Administration & Monitoring

How to code better?

07.09.2023 by Casimir Schmid

Sysadmins are traditionally more operators than developers, they code mainly scripts for automation reasons (shell scripts, Ansible, Terraform, aso). In addition, they can find themselves in situations where they need to analyse code or even decompile programs. Some sysadmins lack(…)

Database Administration & Monitoring

“create user”, “create role”, what should be used in PostgreSQL?

05.09.2023 by Daniel Westermann

Recently we’ve seen a video on YouTube which recommends not to use the “create user” command in PostgreSQL and instead always use the “create role” command. It was also mentioned that “create group” should not be used as well. We’ve(…)

Database Administration & Monitoring

PostgreSQL 17: Allow “\watch” to stop based on the number of rows returned

04.09.2023 by Daniel Westermann

psql already is really powerful but still it gets more features with almost every release of PostgreSQL. One example is the “\watch” meta command. This command was introduced in PostgreSQL 9.3 and hasn’t changed much since(…)

Database Administration & Monitoring

PostgreSQL 17: pg_wait_events

29.08.2023 by Daniel Westermann

As development of PostgreSQL 17 already started there are already some commits which bring in new functionality. One of them introduces a new catalog view called “pg_wait_events”. As the same implies, this view lists the known wait events for PostgreSQL.

Database Administration & Monitoring

PostgreSQL 16: Playing with pg_stat_io (2) – evictions

28.08.2023 by Daniel Westermann

In the last post in this little series we’ve looked at the “extends” statistic in pg_stat_io. In this post we’ll look at the “eviction” statistic. Before we go into the details: What(…)

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

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