News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
AI projects are increasing and with it comes some risks that are or not related to this technology. Some organizations are jumping straight into “plug the LLM into a vector database” ( like Pinecone, Qdrant, pgvector…) at the risk of replaying the lift-and-shift mistakes made on the cloud projects. This time, hiding years of data-quality, […]
I recently had to install an Oracle Database Appliance X11 HA and it failed when creating the appliance: It happened randomly in the past that we got this error “host key verification failed” and we just had to rerun our “odacli create-appliance” command again. However, this time restarting was not possible: Following MOS Note “ODA […]
I recently wrote a blog to show how to configure Veeam RMAN plug-in to take database backups. As all DBA knows, configuring a backup, will not go without testing a restore. In this blog I will show how I tested my previous Veeam configuration and backups performed with this Veeam RMAN plug-in on the same […]
Introduction to YaK YaK is an open-source automation project developed by dbi services. Built on Ansible playbooks, YaK streamlines the deployment process for various components across any platform. It ensures adherence to best practices, maintains deployment quality, and significantly reduces time-to-deploy. Initially created in response to the growing demand from dbi services’ consultants and clients, […]
There are several situations when you have to migrate your Oracle databases to a new server. This could be due to hardware lifecycle reasons for on-prem systems or you need to upgrade your Operating System (OS) from Enterprise Linux 8 to Enterprise Linux 9. In this blog I wanted to talk about my recommended methods […]
Everybody is talking about AI, RAG and language models today. A lot of people are using ChatGPT or other tools to get answers to their questions, generate text or images. While this sometimes is really helpful (depending on how you use it) you still need to be skeptical about the information you get out of […]
This is maybe one the biggest steps forward for PostgreSQL: PostgreSQL 18 will come with support for asynchronous I/O. Traditionally PostgreSQL relies on the operating system to hide the latency of writing to disk, which is done synchronously and can lead to double buffering (PostgreSQL shared buffers and the OS file cache). This is most […]
Last week, I hit a wall when my SUSE Linux Enterprise Server license expired, stopping all repository access. Needing PostgreSQL urgently, I couldn’t wait for SUSE to renew my license and had to act fast.I chose to disable every SLES repository and switched to the openSUSE Leap repository. This worked flawless and made my system […]
Another great feature was committed for PostgreSQL 18 if you are interested how memory is used by a backend process. While you can take a look at the memory contexts for your current session since PostgreSQL 14, there was no way to retrieve that information for another backend. Since PostgreSQL 14 there is the pg_backend_memory_contexts […]
Before we take a look at what this new feature is about, let’s have a look at how PostgreSQL 17 (and before) handles “NOT NULL” constraints when they get created. As usual we start with a simple table: Trying to insert data into that table which violates the constraint of course will fail: Even if […]
Few days ago, through our alerting at the Service Desk, we receive an alert about a database in an AlwaysOn cluster with the message: CRITICAL: Database xxxx [replica: xxxxxx] [role: SECONDARY] state is SUSPECT, synchronization health is NOT_HEALTHY, synchronization state is NOT SYNCHRONIZING [suspended: true] [failover ready: false] [joined: true] After creating the ticket, I […]
When you want to upgrade from one major version of PostgreSQL to another you probably want to go with pg_upgrade (or logical replication). There are several modes of operations for this already: What is best for you, depends on the requirements. We usually go with “–link” as this is pretty fast, but you can only […]
Loosing all the object statistics after a major version upgrade of PostgreSQL with pg_upgrade is one of the real paint points in PostgreSQL. Collecting/generating the statistics can take much longer than the actual upgrade which is quite painful. A first the to resolve this was already committed for PostgreSQL 18 and I’ve written about this […]
Introduction Patching your Oracle Database Appliance from 19.20 or earlier release to 19.21 or newer release implies the use of Data Preserving Reprovisioning (DPR). Most of the time, and with an adequate preparation, the DPR works fine. But if something goes wrong at the restore-node -g step, you will need some troubleshooting and maybe opening […]
Introduction Nowadays, everyone in IT is well versed in using ChatGPT and other LLM powered Chat to retrieve information like Google or try to learn something with it. The problem with those model is there accuracy. Current AI model only know what information they have been fed and expose it to you in a format […]
Many of our customers enable log_connections because of auditing requirements. This is a simple boolean which is either turned on or off. Once this is enabled and active every new connection to a PostgreSQL database is logged into the PostgreSQL log file. Up to PostgreSQL 17, a typical line in the log file for a […]
Recently we faced the following situation and have been asked to analyze the issue: A dump was loaded into a primary instance of PostgreSQL, but the data did not reach the replica. Tables which have been added after the dump was loaded, however made it to the replica. After going through the logs it quickly […]
A very, very long time ago I’ve written a blog about cstore_fdw, which brings columnar storage to PostgreSQL. This is now part of Citus and does not anymore come as a separate extension. While this still can be used there is another option if you’re looking for columnar storage in PostgreSQL, and this is pg_mooncake. […]
We all had that time where we needed to upgrade a ages old system that was running for years without any interruption. This sometimes can be quite tricky and take some time and nerves to do correctly. But since SUSE rocks its amazing YaST (Yet Another Setup Tool), you can nail this setup without deep […]
Here is the How To of scripting them instead Oracle Data Pump can import simple programs without arguments, but it fails when handling Scheduler-Programs that contain arguments. This has been a persistent issue with no official resolution. Since this was a critical challenge in a recent project of mine, I’d like to share my solution. […]
Discover the power of SUSE Multi-Linux Manager, the evolved version of SUMA, capable of managing any Linux distribution. Experience automated patching, security compliance, and system oversight through a single console. Perfect for IT teams seeking efficient, secure management of diverse Linux infrastructures.
Recently I was called by a customer because the failover on a SQL server AlwaysOn 2 nodes cluster does not work. I connect to the first node of AlwaysOn cluster who is the primary and check the cluster with the Failover Cluster Manager. Nothing tells us that it is not working. All is green! It’s […]
This is about another feature which was committed for PostgreSQL 18: Virtual generated columns. Generated columns are available already, but they need to be “STORED”. This means the result of an expression is stored to disk and the result is computed while writing, but you cannot write to that column explicitly. Before looking at the […]