pg_edb博客

SELECT  current_database(), schemaname, tablename, /reltuples::bigint, relpages::bigint, otta,/  ROUND((CASE WHEN otta=0 THEN 0.0 ELSE sml.relpages::FLOAT/otta END)::NUMERIC,1) AS tbloat,  CASE WHEN relpages < otta THEN 0 ELSE bs*(sml.

1.安装PostgreSQL13dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpmdnf -qy module disable postgresqldnf install -y postgresql13-server/usr/pgsql-13/bin/postgresql-13-setup initdb安装后bin目录

1.下载安装包https://ftp.postgresql.org/pub/source/v11beta2/postgresql-11beta2.tar.gz2.解压编译tar -zxvf postgresql-11beta2.tar.gzconfiguremakemake install3.生成postgres组和用户[root@localhost usr]# g...

导入模板后，zabbix监控画面显示postgresql没启动，其实服务器已经启动。查看zabbix-sever.log,发现有以下错误提示。psql.active_connections[{PGHOST},{PGHOST},{PGHOST},{PGPORT},{PGROLE},{PGROLE},{PGROLE},{PGDATABASE}]” became not supported: Rec...

导入pg_monz模板，监控显示postgresql服务没有启动，查看agent端postgresql服务已经启动。查看zabbix-server.log查看到以下错误。 10784:20180809:183958.229 item “agent1:psql.active_connections[{PGHOST},{PGHOST},{PGHOST},{PGPORT},{PGROLE},{PGR...

1.下载安装包https://ftp.postgresql.org/pub/source/v10beta2/postgresql-10beta2.tar.gz2.解压编译tar zxvf postgresql-10beta2.tar.gzconfigureconfigure: creating ./config.statusconfig.status: creating GNUmake...

[postgres@localhost bin]$ ./pg_ctl start -D /usr/pgdata/waiting for server to start…2017-08-11 09:26:19.444 CST [4890] LOG: listening on IPv4 address “0.0.0.0”, port 54322017-08-11 09:26:19.444 CST...

pg_rewind 9.5以及9.6版本，在file的size大于2G以上时，会发生int型溢出。unexpected result while sending file list: ERROR: value “2148022000” is out of range for type integer /* * First create a te...

postgresql10以前版本的分区表是通过继承追加制约实现的，postgresql10新追加PARTITION BY可以直接定义list和range分区，检证如下：postgres=# CREATE TABLE test(id integer,name text) PARTITION BY LIST (id);postgres=# CREATE TABLE test_p1 PARTITIO...

1.查看镜像库中postgres镜像[root@localhost ~]# docker search postgresNAME DESCRIPTION STARS OFFICIAL AUTOMATED...