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(…)
Database Administration & Monitoring Bringing up your customized PostgreSQL instance on Azure 13.08.2018 by Daniel Westermann The Azure cloud becomes more and more popular so I gave it try and started simple. The goal was to provision a VM, compiling and installing PostgreSQL and then connecting to the instance. There is also a fully(…)
Database Administration & Monitoring Backing up and restoring EDB containers in MiniShift/OpenShift 08.08.2018 by Daniel Westermann This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. The last blogs in the series are already some days old: Setting up MiniShift,(…)
Database Administration & Monitoring Catching interface state changes with Network Manager 06.08.2018 by Daniel Westermann Sometimes it is required that you can react on state changes of your network interfaces. Maybe you want to get notified by mail or you want to execute a script that does something in case an event is trapped. As(…)
Database Administration & Monitoring When does PostgreSQL create the table and index files on disk? 05.08.2018 by Daniel Westermann A question that pops up from time to time is: When we create a table or an index in PostgreSQL are the files on disk created immediately or is this something that happens when the first row is inserted? The(…)