[PG] PostgreSQL high availability solution repmgr deployment (very detailed)

Table of Contents Introduction 1 Overview 1.1 Terminology 1.2 Components 1.2.1 repmgr 1.2.2 repmgrd 1.3 Repmgr users and metadata 2 Installation and deployment 2.0 Deployment environment 2.1 Installation requirements 2.1.1 Operating system 2.1.2 PostgreSQL version 2.1.3 Operating system users 2.1.4 Installation location 2.1.5 Version requirements 2.2 Installation 2.2.1 Software package installation 2.2.2 Source code compilation […]

[PG] Configuration file for PostgreSQL high availability solution repmgr management

1 Configuration File 1.1 Configuration file format repmgr.conf is a plain text file containing one parameter/value combination per line. White spaces are irrelevant (except within quoted parameter values), and blank lines are ignored. #Specifies the remainder of the line as a comment. Parameter values that are not simple identifiers or numbers should be enclosed in […]

[Linux] dns domain name resolution service

1. DNS 1.1 Introduction to DNS Domain name resolution: (English: Domain Name System, abbreviation: DNS) is a service of the Internet. As a distributed database that maps domain names and IP addresses to each other, it can make people access the Internet more conveniently. DNS uses udp53 and tcp53. Currently,the length limit for each level […]

[Geek Challenge 2019]BuyFlag 1 (two solutions)

Question environment: FLAG NEED YOUR 100000000 MONEY Flag needs your 100,000,000 yuan F12 Take a look at the source code: if (isset($_POST[‘password’])) {<!– –> $password = $_POST[‘password’]; if (is_numeric($password)) {<!– –> echo “password can’t be number” } elseif ($password == 404) {<!– –> echo “Password Right! } } PHP code audit: Two parameters password and […]

Solution to “Python3.12pip network installation library file error, ssl module is unavailable”

Solution to “Python3.12pip network installation library file error, ssl module is unavailable” 1. Install the new version of openssl3.1.4 2. Install Python3.12.0 The Python version needs to match the openssl version. In versions after Python 3.7, the dependent openssl must be a version after 1.1.1 or 1.0.2, and the openssl1.0.2k installed in CentOS7 cannot meet […]

Linux performance optimization using Tuned configuration optimization solution

Write in front Organizing notes related to exams The blog post covers a simple understanding of Linux tuned tuning tools A brief description of tuning configuration files and an introduction to custom tuning solutions If you don’t understand enough, please help me correct it. There is only one true responsibility for everyone: to find themselves. […]

[Luogu NOIP 2023 Simulation] Solution

This blog has been sitting in the background of my blog for several days, but I just remembered to post it today. plant (plant) First of all, when I saw the number of factors, I thought of considering the problem on the sequence after prime factorization. Further observation shows that the contribution of each dissimilar […]

DevOps application solution based on Docker containers

Table of Contents Experimental requirements: 1. Preparation work 2.gitlab host operation 3. harbor host operation 4. jenkins host operation Write jenkins pipeline script Experimental requirements: 1. Deploy gitlab and upload the code of the above project to your own gitlab warehouse (the first host) 2. Deploy jenkins based on tomcat (second host) 3. Deploy harbor […]

Solution to the “red” message when running tensorfow

Problem display When running tensor, a large amount of “red” information often appears, as shown below: import tensorflow as tf x = tf.constant(1) print(x) code display 2023-11-12 17:39:04.668566: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:01:00.0 name: GeForce MX250 computeCapability: 6.1 coreClock: 1.582GHz coreCount: 3 deviceMemorySize: 2.00GiB deviceMemoryBandwidth: 52.21GiB/s 2023-11-12 17:39:04.668943: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully […]