摘要：
WAL record format typedef struct XLogRecord{pg_crc32 xl_crc; /* CRC for this record */XLogRecPtr xl_prev; /* ptr to previous record in log */Transacti 阅读全文
随笔档案-2016年05月
PostgreSQL auto_explain
2016-05-27 16:45 by DataBases, 494 阅读, 收藏, 编辑
摘要：
The auto_explain module provides a means for logging execution plans of slow statements automatically, without having to run EXPLAIN by hand. This is 阅读全文
CPU informition
2016-05-27 11:41 by DataBases, 326 阅读, 收藏, 编辑
摘要：
tar jxvf util-linux-ng-2.18.bz2cd util-linux-ng-2.18/./configure --enable-arch --enable-partx --enable-write --without-ncursesmakemake install[root@lo 阅读全文
views of postgresql user password and encrypted or unencrypted
2016-05-12 11:27 by DataBases, 582 阅读, 收藏, 编辑
摘要：
password_encryption = onpostgres=# create user user1 with encrypted password 'user1';CREATE ROLEpostgres=# create user user2 with unencrypted password 阅读全文
configs for postgresql restart and postgresql reload
2016-05-11 17:33 by DataBases, 486 阅读, 收藏, 编辑
摘要：
postgres=# select name, setting, contextpostgres-# from pg_settings where context = 'postmaster'; name | setting | context + + allow_system_table_mods 阅读全文
pg_stat_statements
2016-05-05 13:41 by DataBases, 368 阅读, 收藏, 编辑
摘要：
Functions pg_stat_statements_reset() returns void pg_stat_statements_reset discards all statistics gathered so far by pg_stat_statements. By default, 阅读全文
PG sys function
2016-05-04 15:54 by DataBases, 601 阅读, 收藏, 编辑
摘要：
The System Catalogs of PostgreSQLscott=# \dS List of relations Schema | Name | Type | Owner + + + pg_catalog | pg_aggregate | table | postgres pg_cata 阅读全文
replication_slot and PostgreSQL Replication
2016-05-04 15:01 by DataBases, 1387 阅读, 收藏, 编辑
摘要：
主库IP：192.168.230.128 备库IP：192.168.230.129 PostgreSQL版本： 主备机PostgreSQL源码包均位于/opt/soft_bak OS:CentOS5 主备库PostgreSQL均安装在/usr/local/pg952目录下 数据目录均在/usr/lo 阅读全文
