Database Administration & Monitoring Some more zheap testing 03.11.2018 by Daniel Westermann Hervé already did some tests with zheap and documented his results yesterday. After some more discussions with Amit who did the session about zHeap at the conference here in Lisbon (you can(…)
Database Administration & Monitoring Some psql features you are maybe not aware of 25.10.2018 by Daniel Westermann It is the time of The 10th Annual PostgreSQL Conference Europe, so this is the perfect time to blog about some tips and tricks around psql you'll love. psql is such a(…)
Database Administration & Monitoring Inheriting super user privileges over a role automatically in PostgreSQL 16.10.2018 by Daniel Westermann In a recent project at a customer where we synchronize the users and group out of Active Directory we hit a little issue I was not aware of before. Suppose you have created a role in(…)
Database Administration & Monitoring Getting started with Red Hat Satellite – Initial configuration 15.10.2018 by Daniel Westermann In the last post it was all about the Installation of Red Hat Satellite and the components that are used under the hood. In this post it is about doing the initial configuration so that packages(…)
Database Administration & Monitoring Getting started with Red Hat Satellite – Installation 12.10.2018 by Daniel Westermann This is the start of a series of posts I wanted to write for a long time: Getting started with Red Hat Satellite. Just in case you don't know what it is, this statement from the official Red Hat website(…)
Database Administration & Monitoring EDB containers for OpenShift 2.3 – PEM integration 17.09.2018 by Daniel Westermann This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. A few days ago EnterpriseDB announced the availability of version 2.3 of the EDB containers for OpenShift. The main new feature in(…)
We are proud to announce: 14.09.2018 by Daniel Westermann (no words required for this post, the image says it all)(…)
Database Administration & Monitoring When we do a pg_dump and right afterwards truncate a table which is in the dump, what happens? 21.08.2018 by Daniel Westermann Being at customers is always the best way to learn. Today while discussing that pg_dump will always produce a consistent dump because it uses the "repeatable read" isolation level this question came up: What happens when we(…)
Database Administration & Monitoring The size of Oracle Home: from 9GB to 600MB – What about PostgreSQL? 17.08.2018 by Daniel Westermann A recent blog post from Franck and a tweet around that topic is the inspiration for this blog post, thanks Jan for requesting :). In short it is about how small(…)
Database Administration & Monitoring Using the managed PostgreSQL service in Azure 14.08.2018 by Daniel Westermann In the last post we had a look on how you can bring up a customized PostgreSQL instance in the Azure cloud. Now I want to check what you can do with the managed service. For(…)