News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
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
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
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
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
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 […]
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
By the end of the last post we finally got the first OpenStack service up and running: Keystone, the Identity Service. Going back to the list of services we need at a minimum, this still leaves us with some more to setup: In this post we’ll setup the Image Service (Glance) and the Placement service. […]
dbi Blog
By the end of the last post, we finished with preparing the controller and compute node for being ready to deploy the first OpenStack service: Keystone, the Identity Service. Before we dive into the details lets quickly talk about why we need such a service. In an OpenStack setup there needs to be some form […]
dbi Blog
Terraform is a strong open-source declarative and platform agnostic infrastructure as code (IaC) tool developed by HashiCorp. It facilitates the deployment and whole management of infrastructure. In this hands on blog I will show you how you can use Terraform to automate your cloud deployments in Azure. Initial Setup: For this blog I’m using a […]
dbi Blog
While public clouds are a trend since several years now, some companies are also looking into self hosted solutions to build a private cloud. Some do this because of costs, others do this because they don’t want to be dependent on one ore multiple public cloud providers, others do it because they want to keep […]
dbi Blog
In the introduction post we’ve briefly looked at some options you have available when you want to build your own private cloud. In this post we’re going to start our journey into OpenStack by preparing the two nodes we’re going to use for this setup: The controller node, and one compute node. Maybe you remember […]
dbi Blog
For PostgreSQL it is critical, that autovacuum is able to keep up with the changes to the instance. One of the parameters you can adapt for this is autovacuum_max_workers. This parameter controls how many worker process can be started in parallel by the autovacuum launcher process. By default, this is set to 3, which means […]
dbi Blog
Who has never experienced repetitive tasks writing documents based on similar layout content, making sure it is compliant. Don’t you think this activity is using a lot of your precious knowledge worker time and often include small errors or typos? Let’s see how M-Files Ment solution will help you to achieve this goal assuming your […]
dbi Blog
When people talk about containers in FreeBSD, they usually talk about Jails. We’ve already seen how this works in general here and here. An additional option you have, is to install Podman on FreeBSD. Podman is well known in the Linux world and can be used to build and run containers. With the release of […]
dbi Blog
The database Capture/Replay feature of the Real Application Testing (RAT) suite enables you to capture the workload from a production database and replay it on a test or development environment. This allows for realistic testing of database changes, such as upgrades, patches, or hardware migrations. In this blog, we’ll explore how to accomplish this when […]
dbi Blog
Now that we know how to work with the ports collection let’s have a look another option you have in FreeBSD: Sometimes it might be required to run unmodified Linux binaries on FreeBSD and to achieve this, FreeBSD comes with a Linux compatibility layer. This is optional and not enabled by default, but pretty easy […]
dbi Blog
If you followed the previous introduction posts about FreeBSD (here, here, here, here and here) you should already know how to install binary packages. On FreeBSD this is done using pkg, and if you are familiar with apt, dnf, or zypper (or any other package manager on Linux) this should not be a big deal. […]
dbi Blog
Over the years, ORMs have industrialized query generation, allowing developers to focus on optimizing the few queries that truly need it. However, they can sometimes produce overly complex SQL with excessive joins and business logic, making tuning a nightmare. It is sometimes hard to know when you should split a query in multiple smaller parts. […]
dbi Blog
A few days ago a customer called me to ask if I could help him with a problem with the log file. He tried to shrink it, but the system wasn’t doing anything and he didn’t know why. With the column ‘log_reuse_wait_desc’ you can find it out. When I asked him what was in the ‘log_reuse_wait_desc’ […]
dbi Blog
I blogged in the past about running an Oracle database for testing purposes on Apple Silicon. Initially with emulated Intel code here and then (when Oracle released its 19c database software for ARM) with UTM as a wrapper for the QEMU hypervisor here. In the meantime another possibility came up since Oracle released its type […]
dbi Blog
Now that we know how to get started with FreeBSD, how to manage users and groups, and how to work with services, we’ll look a bit into Jails today. But before we do this, let’s look at what we have in Linux today when it comes to containerization and virtual machines. Obviously we can manage […]
dbi Blog
1 Introduction Hello, Readers! Recently, I was tasked with preparing a demo for Power BI Report Server. Everything proceeded smoothly until I reached the step of deploying a report to the server, where I encountered an interesting authentication challenge that highlights the complexities of working with mixed domain environments. The report deployment phase revealed an […]
dbi Blog
Introduction One of the nice things with cloud providers is the low costs of their storage. Whenever you want to optimize your long-term backups and push them on Azure, you might face a wall of questions on how to do it with PostgreSQL securely and whether it would align with disaster recovery plans.The following setup […]
dbi Blog
Contexte : Mon client travail dans le domaine des échanges de marchandises et ressources primaires et son métier repose sur l’utilisation de différents outils informatiques pour faire ses affaires. Dans le but de consolider ses données afin de pouvoir générer des rapports d’activités globaux, dbi-Services a été sollicité pour réaliser un Data Warehouse (DWH) et […]
dbi Blog
This is the third post in the series about getting started with FreeBSD. We’ve looked at the first steps here, and users and groups here. Today we’re looking at how FreeBSD handles services. For those who still don’t like systemd the good news is: There is nothing like systemd in FreeBSD. For those who do […]
dbi Blog
In the last post, we’ve initially configured FreeBSD so that networking is up and running, additional packages can be installed, and the system was patched to the latest release. In this post we’ll look at how users and groups are managed in FreeBSD and what FreeBSD provides when it comes to additional security mechanisms. On […]