Database Administration & Monitoring Going from SLES12 SP2 to SLES12 SP3, online 04.10.2017 by Daniel Westermann SLES 12 SP3 was released some time ago and as we have customers running on that I thought it might be a good idea to test the upgrade from SP2 to SP3. Actually it turned out this(…)
Database Administration & Monitoring Announcing the dbi OpenDB Appliance 28.09.2017 by Daniel Westermann As already announced on Twitter and LinkedIn here is the blog post to describe our OpenDB appliance in more detail. I am sure you wonder what this is about so let me explain why we are(…)
Database Administration & Monitoring Searching wikipedia from the command line 28.09.2017 by Daniel Westermann Wouldn't it be nice if you could search wikipedia from the command line? I often need to quickly look up a definition or want to know more about a specific topic when I am working on the command(…)
Database Administration & Monitoring Be careful when putting the Oracle ADR on xfs, or better 4K sector format drives 21.09.2017 by Daniel Westermann Today, after we did a fresh setup of a Grid Infrastructure cluster (12.1.0.2.170814) we faced two issues reported in the alert.log of the ASM instances (in fact you would see the same for the alert logs of any instance in(…)
Database Administration & Monitoring Developer GUI tools for PostgreSQL 04.08.2017 by Daniel Westermann There was a recent thread on the PostgreSQL general mailing list asking for GUI tools for PostgreSQL. This is question we get asked often at customers so I though it might be good idea to summarize(…)
Database Administration & Monitoring A wonderful PostgreSQL feature: default privileges 04.08.2017 by Daniel Westermann Imagine this scenario (which is not so uncommon): You have a lot of objects in a user schema and you want to grant another user access to that tables. You can easily do this by granting select(…)
Database Administration & Monitoring Re-assigning all objects from on role to another in PostgreSQL 31.07.2017 by Daniel Westermann From time to time it might be required to move objects (tables, indexes, whatever) from one user to another user in a database system. You could do that by dumping all the objects with pg_dump and then(…)
Database Administration & Monitoring Setting up default parameters for roles in PostgreSQL 28.07.2017 by Daniel Westermann As you might know you can set various parameters on the session level in PostgreSQL by using the "set" command: postgres=# h set Command: SET Description: change a run-time parameter Syntax: SET [ SESSION | LOCAL ] configuration_parameter { TO(…)
Database Administration & Monitoring Can I do it with PostgreSQL? – 17 – Identifying a blocking session 25.07.2017 by Daniel Westermann One single blocking session in a database can completely halt your application so identifying which session is blocking other sessions is a task you must be able to perform quickly. In Oracle you can query v$session for(…)
Database Administration & Monitoring Can I do it with PostgreSQL? – 16 – DDL triggers 14.07.2017 by Daniel Westermann A question I received recently from a customer: Oracle gives you the possibility to create DDL triggers. DDL triggers fire (as the name implies) when DDL events occur. Can we do that in PostgreSQL? Yes, this feature(…)