PostgreSQL: Important temBoard Agent Update Version 7.4
Dalibo released yesterday a new version of the temBoard Agent (Version 7.4) It fixes the following error, which was introduced with temBoard Agent (Version 7.3). The issue with that error…
How To Upgrade The TimeZone Version On Oracle 18.1.5 CDB With PDB’s From Version 31 to 33
Why do I need time zone updates at all? Because nothing is more constant than the changes. And one of those are the time zone changes. Some countries remove the…
How To Deploy PostgreSQL 12.4 on Qnap NAS (TVS-682)
In older versions of the Qnap software, you could install PostgreSQL only via the AppCenter, which had the drawback that it supported usually a quite old PostgreSQL version. However, with…
PostgreSQL: How To Schedule Jobs With The pg_cron Extension In Multiple Databases
A new release of the famous pg_cron (v1.3.0) came out on the 6th of October with a lot of cool new features, and a few bug fixes as well. The…
How To Implement Unified Auditing For An Oracle 19c ASM Instance
Do you know what is going on in your Oracle database? Probably yes, because you have implemented auditing and check the audit trail regularly. But do you know what is…
A Few Things You Might Want To Add To Your Backup Strategy If You Have Oracle Restart 19c And ASM
For most people out there in the Oracle wild, a standard RMAN might be sufficient. However, in case you have Oracle Restart and ASM in place, I would consider to…
How to Move the Oracle 19c ASM Password File In And Out of ASM
Per default, the Oracle ASM Password file is located in ASM itself. To be more precise, it is in the following location +DATA/orapwasm which is a symbolic link to orapwasm…
How To Clone A CentOS/RHEL 8.2 Virtual Box VM With A Pre-Installed 19c Oracle Restart Grid Infrastructure
I am planning to clone my Virtual Box VM which is already installed and configured with Oracle Restart 19c and patched with the October 2020 RU (19.9.0.0.0). However, instead of…
How To Create Udev Rules for Oracle 19c ASM on CentOS/RHEL 8.2
In case you want to fire up an Oracle 19c ASM instance on your CentOS/RHEL 8.2, you have a few possibilities. E.g. you could use the asmlib driver or you…
How To Compile PostgreSQL 13 on CentOS 8.2
There are many reasons why you want to compile PostgreSQL yourself. E.g. customized block size, customized set of features, however, the most important one for me is the ability to…