Infrastructure at your Service

Category

Database Administration & Monitoring

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
Petre Radut

When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified

By | Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Oracle | No Comments

Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show parameter undo; NAME TYPE VALUE ———————————— ———– —————————— temp_undo_enabled boolean FALSE undo_management string AUTO undo_retention integer 3600 –extended from 900, undo_tablespace string UNDOTBS1 But, are some scenarios where the above rule is not working . We…

Read More