Database management

DBVISIT StandbyMP for PostgreSQL – 2 – Creating a PostgreSQL configuration

In the previous post we’ve installed the DBVISIT StandbyMP agents on the database nodes, and the management console on third node. In this post we’re going to create our first PostgreSQL configuration.

DBVISIT StandbyMP for PostgreSQL – 1 – Setting it up

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

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

How can LC_* localisation environment variables can break Oracle datapatch

[ORA-20001] How can LC_* localisation environment variables can break Oracle datapatch(…)

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

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

What is the difference between session_user and current_user in PostgreSQL?

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

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

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