Daniel Westermann

Maintenance scenarios with EDB Failover Manager (3) – Witness node

In the last posts ( Maintenance scenarios with EDB Failover Manager (1) – Standby node , Maintenance scenarios with EDB Failover Manager (2) – Primary node ) we looked at how to perform maintenance(…)

Maintenance scenarios with EDB Failover Manager (2) – Primary node

In the last post I looked at how you can do maintenance operations on the standby node when you are working in a PostgreSQL cluster protected by EDB Failover Manager. In this post I'll look on how(…)

The (almost) same sample schema for all major relational databases (2) – Oracle

In the last post we looked at how to install the "Dell DVD Store Database Test Suite" into a PostgreSQL 9.5.2 database. In this post we'll do the same with an Oracle database.

The (almost) same sample schema for all major relational databases (1) – PostgreSQL

The are times when it would be nice to have the same sample schema in all relational databases you or your company are working on. This is great if you want to compare how different databases execute the same tasks(…)

Maintenance scenarios with EDB Failover Manager (1) – Standby node

Recently at a customer we again implemented a PostgreSQL architecture as described some time ago. When we delivered the first draft of the documentation the question popped up how to handle maintenance tasks in a failover cluster(…)

Install PL/JAVA in PostgreSQL 9.5.1

Some time ago I blogged about how to install PL/JAVA in Postgres Plus Advanced Server 9.5. This resulted in an interesting comment from the maintainer of PL/Java. After(…)

Linux quick tip – What is the local time in Kolkata?

Quite easy if you know how to do it from the shell (I didn’t know it 🙂 ): dwe@dwe:~$ TZ='Asia/Kolkata' date Tue Mar 22 19:12:25 IST 2016 You can use “tzselect” to list the available combinations and get the local(…)

Getting started with Ansible – Preparations

When your infrastructure landscape becomes larger and larger you definitely need a tool which helps you in managing your servers, no matter if pḧysical or virtual, running in the cloud or not. One tool (many others are around) which assists(…)

Feeding blogs/rrs items directly into your PostgreSQL database

There are many foreign data wrappers available for PostgreSQL. One of them can be used to query rss feeds. In this post I’ll show you how you can feed summary information of a blog(…)

Pre-warming the buffer cache in PostgreSQL

When a database gets shutdown for patching, operating system maintenance or other reasons you completely lose the contents of the buffer cache. No surprise. Memory is not persistent. Wouldn’t it be nice to load the most important tables to the(…)