All articles

PostgreSQL 12: csv output format for psql

Getting data out of PostgreSQL in csv format is not a big issue. Using copy you can do that easily. PostgreSQL 12 will enhance psql so that you can directly return csv formatted output from a(…)

PostgreSQL 12: log_statement_sample_rate

A common way to identify long running queries in PostgreSQL is to set log_min_duration_statement to a value that is known to cause troubles. In other words: If you know most of your statements usually execute in(…)

AWS re:invent 2018 – Day 4

Thursday morning it’s time for the keynote from Dr Werner Vogels. A big part of the keynote was about databases again. Maybe AWS people knows that there are still lots of DBAs out there! It’s also again a focus on(…)

Extend a Oracle Access Manager 12.2.1.3 with User Messaging Service

After upgrading a Oracle Access Manager from 11.1.2.3 to 12.2.1.3, one of my customer requested from me to configure the Forget Password feature. This feature requires the User Messaging Service that was part of the SOA software in previous versions.

AWS re:invent 2018 – Day 3

On Wednesday morning, this is the big day for AWS re:Invent conference. The day started with a 3 hours keynote from Andy Jassy, CEO of AWS.The keynote covered a lot of different topics: databases, blockchain, machine learning… As most keynotes,(…)

AWS re:invent 2018 – Day 2

Second day in Las Vegas for the AWS re:Invent conference. It was time to travel a little bit around the campus to attend some sessions at the Aria. The planning was still around databases and a bit AWS knowledge. The(…)

No more recovery.conf in PostgreSQL 12

Traditionally everything which is related to recovery in PostgreSQL goes to recovery.conf. This is not only true for recovery settings but also for turning an instance into a replica which follows a master. Some days ago(…)

AWS re:invent 2018 – Day 1

Yesterday was my first day at AWS re:Invent conference. The venue is quite impressive, the conference is split between 6 hotels where you can attend different types of sessions including chalk talk, keynotes, hands-on labs or workshop. For my first day,(…)

SQL Server 2019 CTP 2.1 – A replacement of DBCC PAGE command?

Did you ever use the famous DBCC PAGE command? Folks who are interested in digging further to the SQL Server storage already use it for a while. We also use it during our SQL Server performance(…)

Strange behavior when patching GI/ASM

I tried to apply a patch to my 18.3.0 GI/ASM two node cluster on RHEL 7.5. The first node worked fine, but the second node got always an error...