Upgrading PostgreSQL from 13.6 to 14.11: A Step-by-Step Guide
Migration Context and Requirements
GitLab 17.x requires PostgreSQL 14.9+ as minimum version, necessitating an upgrade from currrent 13.6 deployment. This guide documents the in-place upgrade process for a production streaming replication enviroment.
Version Specifications
Source: PostgreSQL 13.6
Target: PostgreSQL 14.11
Upgrade Procedure
Cre ...
Posted on Sun, 20 Sep 2026 16:32:36 +0000 by Magestic
Linux System Administration: A Practical Guide to Installation, Configuration, and Command-Line Mastery
1. Introduction to Linux
An operating system (OS) manages computer hardware and software resources. It handles memory allocation, device input/output, network operations, and file systems, providing an interface for user interaction.
Major OS Categories by Domain:
Desktop OS: Windows (largest user base), macOS (polished UX, fewer apps, higher ...
Posted on Wed, 16 Sep 2026 16:39:22 +0000 by theoph
Configuring MySQL Master-Slave Replication and Data Synchronization
Initial Data MigrationIf the primary server already contains existing datasets prior to establishing replication, the data must be duplicated to the secondary instance to ensure baseline consistency.Exporting from the Primary HostExecute the following command on the primary Linux machine to generate a complete backup snapshot:mkdir ~/backup_dir ...
Posted on Mon, 14 Sep 2026 16:57:03 +0000 by LuciBKen
Apache Reverse Proxy and Load Balancing Implementation
Apache Reverse Proxy and Load Balancing
1. Reverse Proxy Overview
A reverse proxy is a server that receives requests from clients on the internet and forwards them to servers on an internal network. It then returns the server's responses to the requesting clients. From the external perspective, the reverse proxy appears as the original server ...
Posted on Sat, 12 Sep 2026 16:44:00 +0000 by Malcina
Essential Linux Commands for Development and System Administration
Cross-Compilation Overview
Cross-compilation involves building executables on a high-performance host architecture (like x86) to run on a different target architecture (like ARM). This approach leverages the host's superior resources and tooling, streamlining the development process before deployment to resource-constrained embedded devices.
C ...
Posted on Sun, 06 Sep 2026 16:21:52 +0000 by cdxrevvved
Linux Command Line Fundamentals: A Comprehensive Reference
Linux Directory Structure
The root directory (/) is the top-level directory in Linux. Unlike some operating systems, Linux has only one top-level directory: the root directory. Path relationships are described using the / separator. For example, /home/user/file.txt indicates that there is a file named file.txt in the user directory within the h ...
Posted on Sat, 05 Sep 2026 16:15:08 +0000 by linkskywalker
Practical Docker Deployment and Configuration Guide
Deploying GitLab
To set up a GitLab instance with persistent storage, first create the necessary directory structure on the host machine to hold configuration, logs, and data.
sudo mkdir -p /srv/gitlab/config
sudo mkdir -p /srv/gitlab/logs
sudo mkdir -p /srv/gitlab/data
Launch the GitLab container using the official Community Edition image, ...
Posted on Sun, 30 Aug 2026 16:15:52 +0000 by Ekate
Implementing Real-Time Network Traffic Analysis and Automated Security Policy Management
Real-Time Traffic Monitoring and AnalysisNetwork security relies heavily on the continuous observation of data transmission to identify and mitigate threats before they escalate. Real-time monitoring involves intercepting network packets to analyze their payload, origin, and destination. This process is typically facilitated by security applian ...
Posted on Fri, 21 Aug 2026 16:08:29 +0000 by MaxD
Introduction to Zabbix 3.0 for System Monitoring
Zabbix Overview
Zabbix is a robust, open-source enterprise-class distributed monitoring solution. It provides comprehensive monitoring for networks, servers, applications, and services. While the software is freely available, its development is sustained by a dedicated international team, with commercial support offered as a service. Zabbix's w ...
Posted on Tue, 18 Aug 2026 16:11:43 +0000 by callmubashar
Deploying and Configuring Zabbix Monitoring Infrastructure
Core ArchitectureCentral Server: The primary hub that processes metrics, triggers, and alerts received from monitoring nodes.Data Storage: A backend database (e.g., MySQL/PostgreSQL) retaining all configuration metrics and historical data.Web Interface: The dashboard for visualization and administration, typically co-located with the central se ...
Posted on Mon, 17 Aug 2026 16:12:33 +0000 by eheia