All articles

PostgreSQL 17: login event triggers

This is a feature I am sure a lot of people have waited for and finally it was committed for PostgreSQL 17. Back in my Oracle days it was quite common to have a trigger firing once a user logged(…)

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

PostgreSQL 17: Support for AT LOCAL

When it comes to conversions between time zones in PostgreSQL, there is already much you can do today. What PostgreSQL up to version 16 does not support, is the conversion to the local session’s time zone with ‘AT LOCAL’. Starting(…)

Logs from Filebeat to Logstash to Elasticsearch – 3

We sow together how to install and configure Filebeat, Logstash and Elasticsearch. Our log data has been sent from Filebeat to Logstash, then forwarded to Elasticsearch. In this blog, we will see(…)

Logs from Filebeat to Logstash to Elasticsearch – 2

As promised in the previous blog, I will show how to configure Filebeat to push logs to Logstash, then to Elasticsearch. This for sure will not cover all use cases, but will give you an idea(…)

AWS Monitoring with Zabbix

Until recently, I did not notice that Zabbix templates can also include Hosts prototypes under (Low Level) Discovery Rules. I wondered why, so I decided to look at pre-existing templates to check what is the aim for it. I chose(…)

How the name of the initial superuser is chosen in PostgreSQL

When working with a PostgreSQL instance, most of the time the initial superuser is called “postgres”. One might think this is always the case, and this user is there by default. But the name for that user is chosen by(…)

CloudBees CD/RO – How to use formal output parameter

Did you have issues using output parameter in CloudBees CD/RO or didn’t find much documentation about it? Then you are at the right place. I will present and guide you through an example of how to use the output parameter.

Keep Your Software’s Up to Date with Zabbix

Monitoring tools are increasingly going beyond their usual perimeter of just monitoring metrics. Modern tools, like Zabbix, can watch files for any change and raise warning whenever it occurs. An example I found the “Linux by Zabbix agent” template: Computing(…)

The Case of FileTable with Basic Availability Groups

Using FileTables with Basic Availability Groups in SQL Server offers a robust solution for storing non-relational data but requires careful management due to potential risks like data corruption during long transactions and failovers. While BAG ensures data integrity, challenges arise(…)