PostgreSQL

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

Dealing with corrupted system indexes in PostgreSQL

This is something you do not want to see on an important PostgreSQL system: postgres@centos8pg:/home/postgres/ [pgdev] psql psql: error: could not connect to server: FATAL: index "pg_class_oid_index" contains unexpected zero page at block 0 HINT: Please REINDEX it. The hint(…)

Some words about SOUG Day in Lausanne

Today I participate to SOUG Day which takes place in Lausanne at the "Centre Pluriculturel et social d’Ouchy".

Can there be orphaned data files in PostgreSQL?

PostgreSQL, as all other relational database systems, needs to persist data on disk, either by writing the writing the write ahead log or by synchronization the data files on disk whenever there is a checkpoint. When(…)

PostgreSQL 13 will allow to drop databases even when there are connections

One of the most popular blogs I've written about PostgreSQL was about the three databases that PostgreSQL creates by default (well, actually it is initdb that creates the databases). One of the(…)

Connection pooling with PgBouncer

Some of you may know the case: As soon as the number of users grow, the number of resource problems increases. Have you ever thought about using a connection pooler? Too complex, too much administration effort? In this post I(…)