All articles

What the hell are these template0 and template1 databases in PostgreSQL?

When people start to work with PostgreSQL, especially when they are used to Oracle, some things might be very confusing. A few of the questions we usually get asked are: Where is the listener and how can I configure it?(…)

Securing your connections to PostgreSQL by using SSL

Security is a big topic today and in the news almost every day. As the database usually holds sensitive data this data must be well protected. In most cases this is done by encrypting critical data inside the database and(…)

EDB Failover Manager 2.1, (two) new features

In the last post we upgraded EDB EFM from version 2.0 to 2.1. In this post we'll look at the new features. Actually we'll look only at two of the new features in this(…)

Documentum story – Disable FIPS-140 on a CS 7.2 P05 in order to connect to a 6.7 SP2 repository

In this blog and for a customer’s requirement (Data Migration), I had to temporarily disable the FIPS on a Content Server 7.2 P05 in order to connect to a repository 6.7 SP2. In fact after adding the 6.7 repository to(…)

EDB Failover Manager 2.1, upgrading

Some days ago EnterpriseDB released a new version of its EDB Failover Manager which brings one feature that really sounds great: "Controlled switchover and switchback for easier maintenance and disaster recovery tests". This is(…)

Multitenant thin provisioning: PDB snapshots on ACFS

By Franck Pachot . Database on ACFS is a long story. At first, the main reason for ASM was to bypass a filesystem layer that is not required by the database. ACFS was for the non-database files that had to(…)

Disable Red Hat 7 Transparent Hugepages

Ausgangslage Ein Kunde hat mich kürzlich angefragt, wie am effizientesten alle Kernel Tuning Parameter für Oracle bei Red Hat 7 konfiguriert werden können. Daraus habe ich untersucht welche Möglichkeiten es gibt, ausser dem seit langer Zeit bekannten /etc/sysctl.conf. Bei dieser Analyse(…)

Adaptive Plans and cost of inactive branches

By Franck Pachot . Here are the details about an execution plan screenshot I've tweeted recently because the numbers looked odd. It's not a big problem, or maybe not a problem at all. Just something surprising. I don't like when(…)

Initiate a local GIT repository in command line

Objective of the document is to describe how to start manually with command lines a development project, from an existing GIT repository. Usage of GIT protocol for software development empowers projects team management. It is intended to ease(…)

Auditing in PostgreSQL

Today, especially in the Pharma and Banking sectors, sooner or later you will be faced with the requirement of auditing. Detailed requirements will vary but usually at least tracking logons to the database is a must. Some companies need more(…)