摘要：
OS: Red Hat Enterprise Linux Server release 6.5 (Santiago) PostgreSQL: postgresql-9.4.5.tar.bz2 master: 192.168.0.106 slave1: 192.168.0.108 slave2: 19 阅读全文
随笔档案-2015年12月
PostgreSQL Obtaining the Result Status
2015-12-14 17:09 by DataBases, 681 阅读, 收藏, 编辑
摘要：
There are several ways to determine the effect of a command. The first method is to use the GETDIAGNOSTICS command, which has the form:GET [ CURRENT ]... 阅读全文
PostgreSQL Type的创建与Type在函数中的使用
2015-12-14 15:12 by DataBases, 6118 阅读, 收藏, 编辑
摘要：
postgres=# create type complex as(postgres(# r double precision,postgres(# i double precisionpostgres(# );CREATE TYPEpostgres=# create type inventory_... 阅读全文
BenchmarkSQL测试脚本实现
2015-12-09 10:46 by DataBases, 1322 阅读, 收藏, 编辑
摘要：
sqlTableCreatesDROP SCHEMA IF EXISTS benchmarksql CASCADE;CREATE SCHEMA benchmarksql;create table benchmarksql.warehouse ( w_id integer not ... 阅读全文
PostgreSQL数据导出导入COPY
2015-12-08 17:55 by DataBases, 818 阅读, 收藏, 编辑
摘要：
[postgres@DELL-R720 bin]$ ./psql -p 6432psql (9.4.5)Type "help" for help.postgres=# postgres=# \h copyCommand: COPYDescription: copy data between ... 阅读全文
PostgreSQL 非持久化设置(Non-Durable Settings)
2015-12-08 16:48 by DataBases, 579 阅读, 收藏, 编辑
摘要：
Durability is a database feature that guarantees the recording of committed transactions even if the server crashes or loses power. However, durabilit... 阅读全文
PostgreSQL表空间
2015-12-07 17:52 by DataBases, 662 阅读, 收藏, 编辑
摘要：
postgres=# \h create tablespace Command: CREATE TABLESPACEDescription: define a new tablespaceSyntax:CREATE TABLESPACE tablespace_name [ OWNER ... 阅读全文
PostgreSQL Errors and Messages
2015-12-06 22:09 by DataBases, 484 阅读, 收藏, 编辑
摘要：
使用RAISE语句来报告消息并抛出错误RAISE [ level ] ’format’ [, expression [, ... ]] [ USING option = expression [, ... ] ];RAISE [ level ] condition_name [ USING opti... 阅读全文
PostgreSQL pg_dump pg_dumpall and restore
2015-12-03 15:15 by DataBases, 1962 阅读, 收藏, 编辑
摘要：
pg_dump dumps a database as a text file or to other formats.Usage: pg_dump [OPTION]... [DBNAME]General options: -f, --file=FILENAME output file or dir... 阅读全文
