一、安装
### 下载，解压
wget http://ftp.postgresql.org/pub/source/v9.3.5/postgresql-9.3.5.tar.bz2
tar jxvf postgresql-9.3.5.tar.bz2
### 用户
groupadd postgresql
useradd -g postgresql postgresql
chown -R postgresql:postgresql postgresql-9.3.5
### 编译安装
# 安装目录
mkdir /usr/local/pg935
chown -R postgresql:postgresql /usr/local/pg935
#
cd postgresql-9.3.5
./configure --prefix=/usr/local/pg935
make -j 16
make check
make install
### 初始化"database cluster"(数据目录)
# 创建数据目录
mkdir /home/postgresql/pgdata
cd /usr/local/pg935/
./bin/initdb -D /home/postgresql/pgdata
OR
./bin/pg_ctl -D /home/postgresql/pgdata initdb
###启动数据库
./bin/postgres -D /home/postgresql/pgdata
OR
./bin/pg_ctl -D /home/postgresql/pgdata -l logfile start
### 创建并连接数据库
# 创建数据库'mypg'
./bin/createdb mypg
# 登录数据库'mypg'
psql mypg
点击(此处)折叠或打开
-
[*** pg935]$ psql mypg
-
psql (8.4.11, server 9.3.5)
-
WARNING: psql version 8.4, server version 9.3.
-
Some psql features might not work.
-
Type \"help\" for help.
-
- mypg=#
参考文档列表
Michael Stonebraker@wikipedia Michael Stonebraker@MIT
The PostgreSQL Decade By BRUCE MOMJIAN