PostgreSQL from installation to production: configuration, streaming replication, high availability with Patroni, backups with pgBackRest, performance tuning, extensions, upgrades and migrations from other database engines.
Today I had the chance to move forwar with performance testing and some checks on two Flexible Server – Azure Database for PostgreSQL, one with 8vCPU, 64GB RAM and 512GB Storage (2300 IOPs) and another one with the same vCPU and Memory, but 2TB Storage (7500 IOPs). Microsoft told me that they have replaced the used Linux, from Ubuntu 18.04…
As many know about a year ago I wrote some critical posts about Microsofts Flexible Server for PostgreSQL, now it is time to take a look again. At first, many promised functions where delivered with a latency of about one year or more, for example AAD integration or customer keys. One topic was Compute V4, the Cascade Lake Xeon CPUs…
Introduction TimescaleDB is a “time-series” database (TSDB). This kind of databases are optimized for storing, manipulating and querying time-series data. But… what is time-series data ?Time-series data is a collection of metrics (regular) or measurements (irregular) that are tracked over time. In other words, time-series data is data that collectively represents how a system, process, or behavior changes over time.…
A generic utility to test JDBC connections to any RDBMS or no SQL data source whose JDBC drivers are provided. Listing, PostgreSQL, Oracle Thin.
I already did some talks at conferences and I had already the honor to select talks for a conference. During this talk selection I found some excellent examples on how to do to a proposal, but unfortunately also some examples that could be improved. Also my own learnings from proposals will run into this post, because I know, it’s not…
In the last post we’ve installed and configured the Uyuni server. In this post we’ll add our first client we later on can manage through the Uyuni server. Quite some distributions are supported, and we’re not going for any flavor of openSUSE or SUSE (that for sure will work), but for a Debian 11 client. As our server is running…
This blog is about a fast, script based, setup of a repmgr two node cluster with auto failover. This setup is very easy and the requirements comparing to a patroni setup very low, for exapmle as open port on the firewall we need only port 5432 which ist the default port of PostgreSQL. At first some requirements, in my case…
In the last post we compared the list of databases in the same PostgreSQL cluster using OMrun. The setup for this was pretty simple: We’ve defined the environment using the PostgreSQL Data Adapter and created the connections to two databases. In a new “Test Data Object” we’ve written the SQL statement to list all databases and once the test was…
With the integration of OMIS into dbi services we also got a new product: OMrun. OMrun is all about data, especially comparing, validating and anonymizing data from various sources against various targets. Most of that is done using plain SQL, so we get the full power of SQL for validating, comparing or anonymizing data. In this first introduction post we’ll…
In my last blog we had a look on how to bootstrap a complete Patroni Cluster from pgBackRest. But there is also the possibility to recreate only one Patroni node using pgBackRest. In this blog we will have a look on all the things we need to change to recreate a node successfully from backup. First of all, let’s assume…
Last week I had the pleasure to join the pgconf.eu in Berlin. After three years of waiting since Milan 2019, I was really excited to travel to Berlin to meet all the PostgresFriends again and of course meet a lot of new people. With a new visitor record of 604 participants, we started the conference in a great mood at…
Last week, the biggest European PostgreSQL event of the year took place in Berlin (2022.pgconf.eu). This event is an excellent opportunity to meet developers from the PostgreSQL community and to attend high profile tech presentations. Tuesday evening we started with the traditional “Schweizer Abend” Dinner with the Swiss community. We had a special guest at our table with Frits Hoogland…
