Infrastructure at your Service

Category

Database Administration & Monitoring

Daniel Westermann

Bringing up an OpenShift playground in AWS

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

Before we begin: This is in no way production ready, as the title states. In a production setup you would put the internal registry on a persistent storage, you would probably have more than one master node and you would probably have more than on compute node. Security is not covered at all here. This post is intended to quickly bring up something you can play with, that’s it. In future posts will explore more…

Read More
Cesare Cervini

How to stop Documentum processes in a docker container, and more (part II)

By | Database Administration & Monitoring, Entreprise content management | No Comments

ok, Ok, OK, and the docker part ? In a minute. In part I of this 2-part article, we showed how traps could be used to control a running executable from the outside. We also presented a bash test script to try out and play with traps. Now that we are confident about that simulation script, let’s dockerize it and try it out in this new environment. We use the dockerfile Dockerfile-dctm to create the…

Read More
Daniel Westermann

PostgreSQL 12: Explain will display custom settings, if instructed

By | Database Administration & Monitoring | No Comments

How many times did you try to solve a performance issue but have not been able to reproduce the explain plan? Whatever you tried you always got a different result. Lets say you managed to get a dump of the database in question, got all the PostreSQL parameters the same, gathered statistics but still you do not manage to get the same plan as the one who reported the issue. What could be a potential…

Read More
Daniel Westermann

PostgreSQL 12: Copying replication slots

By | Database Administration & Monitoring | No Comments

The concept of replication slots was introduced in PostgreSQL 9.4 and was created to prevent a primary instance to delete WAL that a replica still needs to apply. That could happen when you have a network interruption or the replica was down for another reason. With replication slots you can prevent that at the downside that your master could fill up your disk if the interruption is too long. This concept of a “physical replication…

Read More
Michael Hein

Second Meetup SOUG / DOAG /AOUG Region Lake of Constance

By | Database Administration & Monitoring | No Comments

Tuesday last week I attended the second meeting of SOUG region lake of constance which took place at Robotron Switzerland in Wil SG. Eleven people attended this event, Georg Russ hold a quite interesting presentation about “Hacked Biometric Data”. He told about how to fake finger prints, iris images, face ids and patterns of hand venes. After this presentation a general discussion about security and other Oracle related themes took place. It was a good…

Read More
Daniel Westermann

The EDB filter log extension

By | Database Administration & Monitoring | No Comments

This is another post dedicated to EnterpriseDB Postgres. Sometimes you may want to get specific messages not getting logged to the server’s logfile or audit records. That might be specific error codes or, even more important, passwords you specify when you create users. EDB comes with a solution for that by providing an extension which is called EDB Filter Log. Lets see how you can install, and even more important, how to use that extension.

Read More
Daniel Westermann

Auditing with EDB Postgres Enterprise

By | Database Administration & Monitoring | No Comments

It might be that there is a requirement to audit operations in the database. Maybe because of legal requirements, maybe because of security requirements or whatever. I’ve already written a post in the past describing what you can do in community PostgreSQL, this post is specific to EDB Postgres. The auditting features come be default in EDB Postgres and you do not need to install any extension such as pgaudit.

Read More