[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 […]

Caching in postgreSQL

1. Introduction to cache ?As shown in the figure below, when a postgreSQL process reads a tuple, it needs to obtain the basic information of the table (such as the oid, index information and statistical information of the table) and the schema information of the tuple. This information is recorded in in multiple system tables. […]

PostgreSQL 14.3 source code installation and debugging

Summary: Introducing PostgreSQL 14.3 source code installation, postgresql usage and vscode source code debugging. 1. Environment preparation 1.1 System parameter modification systemctl status firewalld.service #View fire protection status systemctl stop firewalld.service #Temporarily close the firewall systemctl disable firewalld.service #Permanently close the firewall setenforce 0 #Temporarily close selinux firewall, setenforce is the selinux firewall configuration command […]

02-Basic use of PostgreSQL

1. Database operation ①: Log in to the database psql -U postgres -d postgres -h 127.0.0.1 ②: View all databases \l ③: Create database # Create a database named mydb create database mydb; ④:Switch database # \c database name \c mydb ⑤: Delete database # Before deleting, make sure the database is not connected drop […]

01-PostgreSQL installation and remote connection

1. Windows installation PostgreSQL ①:Download 1. Official website download Address: https://www.postgresql.org/download/ Choose the corresponding system Click to download Select the version to download (I downloaded version 14.X here) Download completed 2. Network disk download Link: https://pan.baidu.com/s/1u3ZcgWb6Woh_0n0ZV2PG9A?pwd=Coke Extraction code: Coke ②: Installation 1. You can first create two folders to store the installation directory and data […]

postgresql|database|materialized view analysis to improve query performance

Foreword: We generally think that the digital world is a virtual world, OK, but in fact some of our needs are exactly the same as those in the real world. For example, for databases, especially relational databases, we hope that the databases we use can be faster (query speed) , higher (higher performance limit), stronger […]

Modify the default MySQL library of cloud package iPortal to POSTGRESQL

Author: John Modify the default MySQL library of cloud package iPortal to POSTGRESQL 1. View iPortal’s configuration persistence directory (iportalOPTs) 2. Modify iportal monitor monitoring 3. Modify iPortal database configuration information 3.1 Modify iPortal database configuration information 3.2 Modify iPortal security database configuration information 3.3 Modify the command executed when the container is started in […]

PostgreSQL logical management structure

1. Introduction to the logical structure of the database 2. Basic database operations 2.1 Create database CREATE DATABASE name [ [ WITH ] [ OWNER [=] user_name ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding ] [ LC_COLLATE [=] lc_collate ] [ LC_CTYPE [=] lc_ctype ] [ TABLESPACE [=] tablespace ] [ CONNECTION […]