Database Administration & Monitoring

How to configure additional listeners on ODA

Introduction Oracle Database Appliance has quite a lot of nice features, but when looking into the documentation, at least one thing is missing. How to configure multiple listeners? Odacli apparently doesn’t know what’s a listener. Let’s find out how to(…)

Be careful with prepared transactions in PostgreSQL

PostgreSQL gives you the possibility for two-phase commit. You'll might need that if you want an atomic distributed commit. If you check the PostgreSQL documentation there is a clear warning about using these kind(…)

Oracle Database Appliance: what have you missed since X3/X4/X5?

Introduction ODA started to become popular with X3-2 and X4-2 in 2013/2014. These 2 ODAs were very similar. The X5-2 from 2015 was different with 3.5 inches disks instead of 2.5 inches and additional SSDs for small databases (FLASH diskgroup).

SQL Server: Control the size of your Transaction Log file with Resumable Index Rebuild

Introduction In this blog post, I will demonstrate how the Resumable capability of Online index rebuild operation can help you to keep the transaction log file size under control. An index rebuild operation is done in a single transaction(…)

[Data]nymizer – Data anonymizer for PostgreSQL

Often there is the requirement to populate a test or development database with data from production, but this comes with a risk: Do you really want, that developers or testers have access to sensitive data? In a lot of companies(…)

8000 PostgreSQL clusters on one host?

Coming back to the last post: 8000 databases in one PostgreSQL cluster?. As we've seen this is doable but comes with a lot of pain points. Another solution for this kind of requirement would be to host(…)

PostgreSQL on FreeBSD, installation from source code

This is the next post in this little series about PostgreSQL on FreeBSD. You can find the previous one here: PostgreSQL on FreeBSD, getting started PostgreSQL on FreeBSD, updating & configuration(…)

PostgreSQL on FreeBSD, installation from packages

In the last two posts we installed FreeBSD, configured networking, updated the system, installed bash and had a quick look at kernel parameters. In this post we'll install PostgreSQL from packages. Of course you(…)

PostgreSQL on FreeBSD, updating & configuration

In the last post we installed FreeBSD, configured the keyboard, time zone and the first network interface, which gets it's IP address via DHCP. In this post we'll look at how we can configure the second interface,(…)

Grafana, SQL and IN() list for multi-value variable

By Franck Pachot . I’ve recently looked at Grafana. Pros: it is really nice, I mean aesthetically. If you want to build a dashboard for your boss, or put it on a large screen in the open space, that’s(…)