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