All articles

PostgreSQL 12: Control when generic plans are used

When you are using prepared statements in PostgreSQL you might get a custom or a generic plan. Custom plans come with overhead of re-planning while generic plans avoid re-planning of the statement.

Securely store passwords in PostgreSQL

Every application somehow needs to deal with passwords. Some use external authentication methods such as ldap, others us the the framework the database already provides and create users and roles. But it is also not uncommon that applications implement their(…)

Can you start two (or more) PostgreSQL instances against the same data directory?

As PostgreSQL does not know the concept of running multiple instances against the same files on disk (e.g. like Oracle RAC) it should not be possible to start two or more instances against the same data directory. If that would(…)

What Benefit You Get From The Cloud For Your Business?

Microsoft, Amazon, Google and Oracle offer infrastructure services whose names change, but the concepts remain the same. It may be that you are interested in the cloud too, but it's still not clear because you find(…)

SUSE Expert Day Zürich

On May 16th I visited the SUSE Expert Day in Zürich. An interesting Agenda was waiting for me, all under the topic: "My kind of open"(…)

Documentum – FT – Document not found using search from D2

At a customer, I received an incident saying that on D2 a document is found by browsing and not found using normal search. The root cause seems to be easy: The Document isn't indexed?! Not really, you will see it(…)

Documentum – Delete Remote Docbase – Strange behavior

In the previous blog I showed you how to decommission a remote Content Server by deleting remote Docbase(s) and Docbroker(s). In fact, when I tried to delete remote Docbases I encounter a strange behavior, and it(…)

Documentum – Remote Content Server Decommission

I already experienced the installation of a remote Content Server but it was my first decommissioning, and as usual the decommission is faster than the installation ;) by the way, read this blog if you missed(…)

Configuring Oracle DB data source in JBoss EAP 7.1

Introduction This blog explains how to install and use an Oracle database JDBC driver in JBoss EAP 7.1 standalone instance and in a domain deployment. Oracle JDBC driver installation The first step is to install the JDBC driver in(…)

APEX Connect 2019 – Day 3

For the last conference day, after the Keynote about “JavaScript, Why Should I Care?” by Dan McGhan , I decided to attend some JavaScript learning sessions to improve myself and presentations on following topics: – How to hack your(…)