欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜:Formal mathematics/Isabelle/ML, Formal verification/Coq/Agda, C++/Erlang/Lisp
PostgreSQL
来自开放百科 - 灰狐
(版本间的差异)
第11行: | 第11行: | ||
chown postgres /usr/local/pgsql/data | chown postgres /usr/local/pgsql/data | ||
su - postgres // sudo su postgres | su - postgres // sudo su postgres | ||
− | /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data | + | /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data |
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 & | /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 & | ||
/usr/local/pgsql/bin/createdb test | /usr/local/pgsql/bin/createdb test |
2006年7月21日 (五) 20:41的版本
PostgreSQL: The world's most advanced open source database
目录 |
安装指南
./configure gmake // ln -s /usr/bin/make /usr/bin/gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su - postgres // sudo su postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 & /usr/local/pgsql/bin/createdb test /usr/local/pgsql/bin/psql test
stop postgresql
su postgres or sudo su postgres /usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data/
PostgreSQL Limits
Limit Value
- Maximum Database Size Unlimited
- Maximum Table Size 32 TB
- Maximum Row Size 1.6 TB
- Maximum Field Size 1 GB
- Maximum Rows per Table Unlimited
- Maximum Columns per Table 250 - 1600 depending on column types
- Maximum Indexes per Table Unlimited
PostgreSQL发行版
- http://www.postgresql.org
- EnterpriseDB http://www.enterprisedb.com/
- Pervasive http://www.pervasive.com/
相关链接
- PostgreSQL 中文网 http://www.pgsqldb.org/
分享您的观点