[平台环境]
CentOS6.5 PostgreSQL:postgresql-9.3.5-1-linux.run
1、root用户下赋予postgresql-9.3.5-1-linux.run执行权限,并默认安装到/opt/PostgreSQL/9.3目录下
# chmod u+x postgresql-9.3.5-1-linux.run
# ./postgresql-9.3.5-1-linux.run
(均按默认安装,回车即可)
(之后会自动创建postgres用户、用户组)
#会看到服务已自动添加好
# chkconfig --list | grep -i postgres
postgresql-9.3 0:off 1:off 2:on 3:on 4:on 5:on 6:off
#会看到服务端口已处于监听状态
# netstat -an | grep 5432
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN
tcp 0 0 :::5432 :::* LISTEN
unix 2 [ ACC ] STREAM LISTENING 22469 /tmp/.s.PGSQL.5432
# passwd postgres
(修改postgres用户的密码)
# chown -R postgres:postgres /opt/PostgreSQL
2、为postgres用户设置home目录(/opt/PostgreSQL/9.3)、环境变量
# cd /root
# cp .bash_profile /opt/PostgreSQL/9.3
# cp .bashrc /opt/PostgreSQL/9.3
# chown postgres:postgres /opt/PostgreSQL/9.3/.bash_profile
# chown postgres:postgres /opt/PostgreSQL/9.3/.bashrc
3、以postgres用户登陆,修改环境变量
$ vi .bashrc
#添加以下内容
export PGHOME=/opt/PostgreSQL/9.3
export PATH=$PGHOME/bin:$PATH
export PGDATA=$PGHOME/data
export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH
export PGDATABASE=mydb
export PGPORT=5432
4、以postgres用户测试数据库连接
$ psql -d postgres -U postgres
Password for user postgres:
psql.bin (9.3.5)
Type "help" for help.
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)
5、如果其他机器访问该数据库,还需修改/opt/PostgreSQL/9.3/data/pg_hba.conf 和 postgresql.conf文件
6、数据库启停
# service postgresql-9.3 stop
# service postgresql-9.3 start
或者,如果配置了环境变量export PGDATA=/opt/PostgreSQL/9.3/data,则可以在postgres用户下执行
$ pg_ctl stop
$ pg_ctl start