BE SHARING

Database Administration & Monitoring

DBVISIT StandbyMP for PostgreSQL – 1 – Setting it up

27.10.2023 by Daniel Westermann

One of our oldest partners, DBVISIT, recently released their product StandbyMP for PostgreSQL. The goal of this product is to provide a graphical user and management interface over a PostgreSQL streaming replication(…)

Locales, collations, encodings and the PostgreSQL sort order (2) – sorting strings

25.10.2023 by Daniel Westermann

In the last post we’ve looked at how you can tell initdb which character set and locale it should use for the initial databases. In this post we’ll look at how you(…)

Database Administration & Monitoring

Locales, collations, encodings and the PostgreSQL sort order (1) – basics

20.10.2023 by Daniel Westermann

When it comes to sorting strings it is all about locales and how PostgreSQL is using them. PostgreSQL uses the locales provided by the underlying operating system, by default this is “C” or “POSIX”. To see(…)

Database Administration & Monitoring

What is the difference between session_user and current_user in PostgreSQL?

19.10.2023 by Daniel Westermann

When you want to know the currently connected user in PostgreSQL for your session there are two system information functions which seem to do the same thing. There is “session_user” and there is “current_user”. So what is the difference between(…)

Database Administration & Monitoring

PostgreSQL 17: login event triggers

18.10.2023 by Daniel Westermann

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

Database Administration & Monitoring

PostgreSQL 17: Support for AT LOCAL

13.10.2023 by Daniel Westermann

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

Database Administration & Monitoring

How the name of the initial superuser is chosen in PostgreSQL

12.10.2023 by Daniel Westermann

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

Database Administration & Monitoring

SQL Server: How to shrink the T-log file for a lot of old user-databases

06.10.2023 by Stéphane Haby

Recently I have the case that a customer has a lot of databases not more used but need to be accessible at any time. In this case, we had a lot of T-log with the size when there are used(…)

Database Administration & Monitoring

New Features 23c, Overview (in extracts):

29.09.2023 by Christian Weinfurtner

In this blog I want to introduce some of the new features of the Oracle 23c developer edition. It will be only a selection of some of the main features. It is not the intention to give you a thorough(…)

Database Administration & Monitoring

Oracle Lock Free Reservations

27.09.2023 by Lazhar Felahi

The Oracle 23c new feature Lock Free Reservations allows to break with the traditional locking mechanism. Now multiple concurrent sessions can update the same row without be blocked !!! Let’s see how it works. In the traditional locking mechanism,(…)