| 库过滤器 | 表过滤器 | 主机: 0 码力 |
17 页 |
445.84 KB
| 2 年前 3 4。目前（2019/04/23）主干分支的代码基于PostgreSQL 9.4。合并到PostgreSQL 9.5的工作也已经开始，有关最新工作进展请参见：https://github.com/greenplum-db/gpdb- postgres-merge。
### 1. 从源代码编译 Greenplum
Greenplum 目前官方支持 Redhat/Centos/SuSE/Ubuntu 等 Linux 系统。大量开发人员包括我自己使用 master/greenplum_path.sh
$ export PGHOST='hostname'
$ make
$ source gpdemo-env.sh
$ psql postgres
postgres# SELECT version()
有关更详细的信息请参考 README.macOS.md。
### 1.2 在 Redhat/Centos 系统上编译
本小节以 RHEL7 $ source gpdemo-env.sh
$ psql postgres
version
PostgreSQL 8.3.23 (Greenplum Database 5.4.1+dev.56.gcdfadd9 build dev) ...
postgres=# SELECT * FROM gp_segment_configuration 0 码力 |
15 页 |
2.07 MB
| 2 年前 3 with 3.6)
• Built-in support for SQLite, MySQL and Postgresql.
• numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and
much more).
Peewee’s source tests against Postgres or MySQL you need to create a database named “peewee_test”. To test the
Postgres extension module, you will also want to install the HStore extension in the postgres test database: database:
-- install the hstore extension on the peewee_test postgres db.
CREATE EXTENSION hstore;
1.1.3 Optional dependencies
Note: To use Peewee, you typically won’t need anything outside the standard library 0 码力 |
284 页 |
1.03 MB
| 1 年前 3 with 3.6)
• Built-in support for SQLite, MySQL and Postgresql.
• numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and
much more).
Peewee’s source tests against Postgres or MySQL you need to create a database named “peewee_test”. To test the
Postgres extension module, you will also want to install the HStore extension in the postgres test database: database:
-- install the hstore extension on the peewee_test postgres db.
CREATE EXTENSION hstore;
1.1.3 Optional dependencies
Note: To use Peewee, you typically won’t need anything outside the standard library 0 码力 |
282 页 |
1.02 MB
| 1 年前 3 tests against Postgres or MySQL you need to create a database named “peewee_test”. To test the
Postgres extension module, you will also want to install the HStore extension in the postgres test database: database:
-- install the hstore extension on the peewee_test postgres db.
CREATE EXTENSION hstore;
1.1.3 Optional dependencies
Note: To use Peewee, you typically won’t need anything outside the standard library there are many DB-API 2.0-compatible drivers out there, such as pymysql or psycopg2
for MySQL and Postgres respectively.
• Cython: used for various speedups. Can give a big boost to certain operations, particularly 0 码力 |
302 页 |
1.02 MB
| 1 年前 3 with 3.6)
• Built-in support for SQLite, MySQL and Postgresql.
• numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and
much more).
Peewee’s source tests against Postgres or MySQL you need to create a database named “peewee_test”. To test the
Postgres extension module, you will also want to install the HStore extension in the postgres test database: database:
-- install the hstore extension on the peewee_test postgres db.
CREATE EXTENSION hstore;
1.1.3 Optional dependencies
Note: To use Peewee, you typically won’t need anything outside the standard library 0 码力 |
280 页 |
1.02 MB
| 1 年前 3 with 3.6)
• Built-in support for SQLite, MySQL and Postgresql.
- numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and much more).
Scaling with PostgreSQL 9.6 and Postgres-XL### Scaling with PostgreSQL 9.6 and Postgres-XL Mason Sharp mason.sharp@gmail.com Huawei ## whoami • Engineer at Huawei (USA based) • Co-organizer of NYC PostgreSQL User Group • PostgreSQL-based PostgreSQL-based database clusters GridSQL • Postgres-XC • Postgres-XL ## Agenda • PostgreSQL 9.6 Scaling Features • Scaling Solutions • Use Cases • Postgres-XL ## BTW- PGConf US 2017 in New York City • Join us cores largely idle - Prior to 9.6, one work-around for this would be to configure a multi-node Postgres-XL “cluster” on the same server, which would utilize the other cores • PostgreSQL 9.6 adds parallel0 码力 | 87 页 | 1.16 MB | 2 年前3
postgresql操作手册现在想修改为/data_pg/ 目录 ★PG-13 版本 # systemctl stop postgresql-13 #先停止服务 # mkdir /data_pg # chown postgres:postgres /data_pg # vi /var/lib/pgsql/13/data/postgresql.conf #pg-13 版本，添加或修改以下配置 data_directory = restart postgresql-13 ★PG-10 版本 # systemctl stop postgresql #先停止服务 # mkdir /data_pg # chown postgres:postgres /data_pg # vi /var/lib/pgsql/data/postgresql.conf #pg-10 版本，添加或修改以下配置 data_directory = 5432/tcp # firewall-cmd --add-port=5432/tcp --permanent # firewall-cmd --reload pg_hba.conf 配置保存在 postgres 库下面的名为 pg_catalog 的 schema 下的 pg_hba_file_rules 表里：
peewee Documentation Release 3.1.0with 3.6) • Built-in support for SQLite, MySQL and Postgresql. - numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and much more). ![Image](/uplo tests against Postgres or MySQL you need to create a database named “peewee_test”. To test the Postgres extension module, you will also want to install the HStore extension in the postgres test database: database: -- install the hstore extension on the peewee_test postgres db.CREATE EXTENSION hstore; ## Optional dependencies ## Note To use Peewee, you typically won’t need anything outside the standard library0 码力 | 332 页 | 370.77 KB | 1 年前3共 703 条