欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜:Formal mathematics/Isabelle/ML, Formal verification/Coq/ACL2, C++/F#/Lisp
PostgreSQL
来自开放百科 - 灰狐
(版本间的差异)
第10行: | 第10行: | ||
mkdir /usr/local/pgsql/data | mkdir /usr/local/pgsql/data | ||
chown postgres /usr/local/pgsql/data | chown postgres /usr/local/pgsql/data | ||
− | 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 | ||
/usr/local/pgsql/bin/psql test | /usr/local/pgsql/bin/psql test | ||
+ | |||
+ | stop postgresql | ||
+ | /usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data/ | ||
==PostgreSQL Limits== | ==PostgreSQL Limits== |
2006年7月21日 (五) 17:26的版本
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
/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/
分享您的观点