News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
dbi Blog
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 […]
dbi Blog
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 […]
dbi Blog
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 […]
dbi Blog
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 […]
dbi Blog
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 […]
dbi Blog
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 […]
dbi Blog
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 […]
dbi Blog
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. […]
dbi Blog
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. […]
dbi Blog
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.
dbi Blog
Introduction The first release of pgvector occurred in April 2021. Since then a lot has changed and is still changing. Even though we could say that the level of maturity of AI stacks and usage is currently really amazing, things are still changing fast and will probably continue to do so for a while. This […]
dbi Blog
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 […]
dbi Blog
A client submitted the following issues : During an audit of their environment, we also noticed that the database data files were hosted on a volume using an MBR partition type (which is limited to 2 TB). 2 tables were involved (but only one needed to be partitioned, the “Data” table) because we had a […]
dbi Blog
cleanup Oracle-Home(s) after applying the quarterly Release Updates Do you suffer from the fact that release updates take longer each time?Are you afraid that your hard disk will fill up because the Oracle-Home is getting bigger and bigger?Here is the how-to for cleaning up your environment. A) cleanup – option 1 for Out-Of-Place patching According […]
dbi Blog
Azure Database watcher is a managed monitoring service designed to provide insights and diagnostics for Azure databases and Azure Managed Instance. It helps database administrators and developers track performance, detect anomalies and troubleshoot issues efficiently. By collecting telemetry data, logs and metrics, Azure Database watcher enables proactive monitoring and alerting, ensuring database health and optimal […]
dbi Blog
Vacuum/Autovacuum is one of the critical parts of every PostgreSQL installation. When autovacuum is not configured properly for your workload you’ll suffer from bloat and performance issues sooner or later. Most of the installations we’ve seen run with the defaults just fine, and a lot of people probably never need to deal with adjusting any […]
dbi Blog
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 […]
dbi Blog
Problem defintion I encountered an issue with the configuration of an external connector in the M-Files Server 25.1 (January 2025). In my case, this was the M-Files Network Folder Connector. The installation of the Vault Application proceeded smoothly, as usual. I then attempted to configure the connector in the M-Files Admin Tool, but encountered a […]
dbi Blog
Business requirements Solution A dedicated folder system is in place to manage all documentation and versions, ensuring compliance with requirements. The system incorporates a process for document approval and review, with tracking capabilities. The language of the documents is a key component of their metadata, with relevant information found on the metadata card and in […]
dbi Blog
This is about another feature which will most likely show up in PostgreSQL 18 later this year. The statistic system is something which gets more and more details with almost every release of PostgreSQL, and PostgreSQL 18 will be no exception to that. When you take a look at pg_stat_all_tables (or pg_stat_user_tables) in PostgreSQL 17, […]
dbi Blog
When your DB infrastructure move to ExaCC, it’s a good option to appropriate the tools offer by it to facilitate your life. And for ExaCC, this tool is dbaascli. It manages many aspects of the ExaCC layers. And in this blog, we focus on the clone remote PDB with dbaascli! The environment used for this […]
dbi Blog
We’ve finished the last post with a working Network (Neutron) service on the controller and compute node. In this post we’ll setup the final service which is Horizon, the OpenStack dashboard. Once more, looking back at what we need at a minimum, we’ve done most of it by now: Currently, the overview of our playground […]
dbi Blog
We’ve finished the last post with a working Compute (Nova) service on the controller and compute node. While only the compute(s) actually run compute resources, Nova is also running on the controller for the management tasks, while libvirt is only running on the compute node. Once more, looking back at what we need at a […]
dbi Blog
We’re now coming closer to the final setup of the OpenStack test environment. Again, looking at the minimum services we need, there are only three of them left: In this post we’ll continue with the Compute Service, which is called Nova. As a short reminder, if you followed the last posts, this is what we […]
dbi Blog
While doing some research on OpenStack (see here for the introduction post), I thought blogging about a new feature for the next version of PostgreSQL might free my head a bit from all those OpenStack services, so here we go 🙂 What you can do in PostgreSQL since a very long time, is to return […]