PostgreSQL

Setup a two node Postgres HA Cluster using EDB Advanced Server and EFM

Some time ago I had a customer looking for a two node PostgreSQL Master/Replica solution. As we need Oracle compatibility in a later step, we decided to go with the EnterpriseDB tools. This article should give you an introduction on(…)

Adding PostgreSQL extensions without being super user?

Usually, when you need to install a PostgreSQL extension you do this as superuser (or at least I am doing it like this). The downside of that is, of course, that a super user must be available once a new(…)

PostgreSQL 13: parallel vacuum for indexes

Because of its implementation of MVCC PostgreSQL needs a way to cleanup old/dead rows and this is the responsibility of vacuum. Up to PostgreSQL 12 this is done table per table and(…)

Deploying your own PostgreSQL image on Nutanix Era – 2 – Deploying a new PostgreSQL VM

In the last post I described how you can create your own PostgreSQL image in Nutanix Era. In Nutanix wording this is a "Software profile". This profile can now be used to deploy PostgreSQL VMs with(…)

Deploying your own PostgreSQL image on Nutanix Era

Some days ago we had a very good training on Nutanix. Nutanix is a Hyper-converged infrastructure and that means that all is software driven and the system can be deployed on many(…)

One Host, multiple PostgreSQL Clusters – Monitoring using EDB PEM

At a customer we implemented the EDB Postgres Enterprise Manager. As they run multiple PostgreSQL cluster on one server, they wanted, for sure, to monitor all the cluster using PEM. This blog should give you a short guidance on(…)

Real time replication from Oracle to PostgreSQL using Data Replicator from DBPLUS

I've done quite some real time logical replication projects in the past, either using Oracle Golden Gate or EDB replication server. Build in logical replication in PostgreSQL (which(…)

Enabling, disabling, and validating foreign key constraints in PostgreSQL

Constraints are in important concept in every realtional database system and they guarantee the correctness of your data. While constraints are essentials there are situations when it is required to disable or drop them temporarily. The reason could be performance(…)

A schema and a user are not the same in PostgreSQL

When people with an Oracle background attend our PostgreSQL DBA Essentials training there is always a bit of confusion about schemas and users. In Oracle a schema and(…)

Fun with arrays in PostgreSQL

As you might already know, PostgreSQL comes with many, many data types. What you might not know is, that you can create arrays over all this data types quite easily. Is that(…)