PostgreSQL
Expect-乐
兴趣是最大的动力。
展开
-
PG 查看系统安装创建时间
通过以下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原创 2021-03-11 16:39:01 · 740 阅读 · 0 评论 -
Postgre 11 等待类型和等待事件说明
官方文档:https://www.postgresql.org/docs/11/monitoring-stats.html#WAIT-EVENT-TABLEWait Event Type Wait Event Name Description LWLock ShmemIndexLock Waiting to find or allocate space in shared memory. OidGenLock Waiting to allocate or assig转载 2020-12-10 16:49:59 · 1439 阅读 · 0 评论 -
PostgreSQL 12 开始 recovery.conf配置整合到postgresql.conf中
官方文档说明:Integrate recovery.conf into postgresql.conf recovery.conf settings are now set in postgresql.conf (or other GUCsources). Currently, all the affected settings are PGC_POSTMASTER;this could be refined in the future case by case. Recovery is n原创 2020-11-10 08:52:44 · 930 阅读 · 0 评论 -
利用Docker部署 PostgreSQL 12.4主从
通过 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可根据自己原创 2020-11-09 17:08:42 · 1755 阅读 · 0 评论 -
Centos 7 上编译安装PostgreSQL 9.0报错:FATAL: wrong number of index expressions
报错信息:-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原创 2020-11-06 10:51:59 · 680 阅读 · 0 评论