PostgreSQL：PostgreSQL的安装和配置

一、在CentOS上安装PostgreSQL数据库 

下面我们就以CentOS系统为例，给大家讲解一下PostgreSQL的安装过程。 

1.使用yum安装postgresql 

[pengchengxiang@localhost ~]$ sudo yum install postgresql-server.x86_64 
Loaded plugins: fastestmirror, refresh-packagekit, security 
Setting up Install Process 
Loading mirror speeds from cached hostfile 
 * base: mirrors.btte.net 
 * extras: mirror.bit.edu.cn 
 * updates: mirror.bit.edu.cn 
Resolving Dependencies 
--> Running transaction check 
---> Package postgresql-server.x86_64 0:8.4.20-3.el6_6 will be installed 
--> Processing Dependency: postgresql(x86-64) = 8.4.20-3.el6_6 for package: postgresql-server-8.4.20-3.el6_6.x86_64 
--> Running transaction check 
---> Package postgresql.x86_64 0:8.4.20-3.el6_6 will be installed 
--> Finished Dependency Resolution 
Dependencies Resolved 
================================================================================ 
 Package                 Arch         Version               Repository     Size 
================================================================================ 
Installing: 
 postgresql-server       x86_64       8.4.20-3.el6_6        updates       3.4 M 
Installing for dependencies: 
 postgresql              x86_64       8.4.20-3.el6_6        updates       2.6 M 
Transaction Summary 
================================================================================ 
Install       2 Package(s) 
Total download size: 6.0 M 
Installed size: 28 M 
Is this ok [y/N]: y 
Downloading Packages: 
(1/2): postgresql-8.4.20-3.el6_6.x86_64.rpm              | 2.6 MB     00:02      
(2/2): postgresql-server-8.4.20-3.el6_6.x86_64.rpm       | 3.4 MB     00:06      
-------------------------------------------------------------------------------- 
Total                                           680 kB/s | 6.0 MB     00:09      
Running rpm_check_debug 
Running Transaction Test 
Transaction Test Succeeded 
Running Transaction 
  Installing : postgresql-8.4.20-3.el6_6.x86_64                             1/2  
  Installing : postgresql-server-8.4.20-3.el6_6.x86_64                      2/2  
  Verifying  : postgresql-8.4.20-3.el6_6.x86_64                             1/2  
  Verifying  : postgresql-server-8.4.20-3.el6_6.x86_64                      2/2  
Installed: 
  postgresql-server.x86_64 0:8.4.20-3.el6_6                                      
Dependency Installed: 
  postgresql.x86_64 0:8.4.20-3.el6_6                                             
Complete! 

2.初始化postgresql数据库 

[pengchengxiang@localhost ~]$ sudo service postgresql initdb 
Initializing database: [  OK  ] 

2.启动postgresql服务