Expec-乐的博客

通过以下SQL查看系统标识 postgres=# select system_identifier from pg_control_system(); system_identifier --------------------- 6858150323694115572 (1 row) 或通过pg_controldata查看系统标识Database system identifier [postgres@test98 ~]$ pg_controldata pg_control version

官方文档:https://www.postgresql.org/docs/11/monitoring-stats.html#WAIT-EVENT-TABLE Wait Event Type Wait Event Name Description LWLock ShmemIndexLock Waiting to find or allocate space in shared memory. OidGenLock Waiting to allocate or assig

官方文档说明： Integrate recovery.conf into postgresql.conf recovery.conf settings are now set in postgresql.conf (or other GUC sources). Currently, all the affected settings are PGC_POSTMASTER; this could be refined in the future case by case. Recovery is n

通过 Docker 部署 PG 主从 主要用于测试，通过 Docker 快速部署 PG 主从。 环境架构 基于PG 12.4 版本安装 IP 角色 172.18.12.100 主 172.18.12.101 从 部署 下载镜像，运行容器，配置主从。 步骤1：下载镜像 [root@lei ~]# docker pull postgres:12.4-alpine 官方镜像地址:https://hub.docker.com/_/postgres?tab=description 可根据自己

报错信息： -bash-4.2$ /usr/local/pg9.0/bin/initdb -D /usr/local/pg9.0/data/ The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale en_US.UTF