1.下载:

anzhuang  jDK

http://blog.csdn.net/youzhouliu/article/details/51183115

-------------------------------

http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

http://www.cnblogs.com/tjpanda88/p/4306149.html

---------------------------------------------------------------------------------------------------------------

2.//官方安装_Postgresql

https://www.postgresql.org/download/linux/redhat/

3.//博客安装过程

http://blog.csdn.net/lk10207160511/article/details/50359549

http://www.jianshu.com/p/7e95fd0bc91a

1.添加RPM

　　
[root@localhost ~]# yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-2.noarch.rpm
Loaded plugins: fastestmirror, langpacks
pgdg-centos95-9.5-.noarch.rpm | 5.3 kB :
Examining /var/tmp/yum-root-a5MmUk/pgdg-centos95-9.5-.noarch.rpm: pgdg-centos95-9.5-.noarch
Marking /var/tmp/yum-root-a5MmUk/pgdg-centos95-9.5-.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package pgdg-centos95.noarch :9.5- will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================

Package Arch Version Repository Size

Installing:
pgdg-centos95 noarch 9.5- /pgdg-centos95-9.5-.noarch 2.2 k

Transaction Summary

Install Package

Total size: 2.2 k
Installed size: 2.2 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found pre-existing rpmdb problem(s), 'yum check' output follows:
ipa-client-4.4.-.el7.centos.x86_64 has installed conflicts freeipa-client: ipa-client-4.4.-.el7.centos.x86_64
ipa-client-common-4.4.-.el7.centos.noarch has installed conflicts freeipa-client-common: ipa-client-common-4.4.-.el7.centos.noarch
ipa-common-4.4.-.el7.centos.noarch has installed conflicts freeipa-common: ipa-common-4.4.-.el7.centos.noarch
:java-1.8.-openjdk-headless-1.8.0.102-.b14.el7.x86_64 has missing requires of tzdata-java >= ('', '2015d', None)
Installing : pgdg-centos95-9.5-.noarch /
Verifying : pgdg-centos95-9.5-.noarch /

Installed:
pgdg-centos95.noarch :9.5-

Complete!

2.安装PostgreSQL 9.5

[root@localhost ~]# yum install postgresql95-server postgresql95-contrib
Loaded plugins: fastestmirror, langpacks
Repository pgdg95 is listed more than once in the configuration
Repository pgdg95-source is listed more than once in the configuration
Loading mirror speeds from cached hostfile
* base: mirrors.cn99.com
* extras: mirrors.aliyun.com
* updates: mirrors.aliyun.com
Resolving Dependencies
--> Running transaction check
---> Package postgresql95-contrib.x86_64 :9.5.-2PGDG.rhel7 will be installed
--> Processing Dependency: postgresql95-libs(x86-) = 9.5.-2PGDG.rhel7 for package: postgresql95-contrib-9.5.-2PGDG.rhel7.x86_64
--> Processing Dependency: postgresql95(x86-) = 9.5.-2PGDG.rhel7 for package: postgresql95-contrib-9.5.-2PGDG.rhel7.x86_64
--> Processing Dependency: libpq.so.()(64bit) for package: postgresql95-contrib-9.5.-2PGDG.rhel7.x86_64
---> Package postgresql95-server.x86_64 :9.5.-2PGDG.rhel7 will be installed
--> Running transaction check
---> Package postgresql95.x86_64 :9.5.-2PGDG.rhel7 will be installed
---> Package postgresql95-libs.x86_64 :9.5.-2PGDG.rhel7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================

Package Arch Version Repository Size

Installing:
postgresql95-contrib x86_64 9.5.-2PGDG.rhel7 pgdg95 k
postgresql95-server x86_64 9.5.-2PGDG.rhel7 pgdg95 4.1 M
Installing for dependencies:
postgresql95 x86_64 9.5.-2PGDG.rhel7 pgdg95 1.3 M
postgresql95-libs x86_64 9.5.-2PGDG.rhel7 pgdg95 k

Transaction Summary

Install Packages (+ Dependent packages)

Total size: 6.1 M
Total download size: k
Installed size: M
Is this ok [y/d/N]: y
Downloading packages:
pgdg95//x86_64/prestodelta | kB :
postgresql95-contrib-9.5.-2PGDG.rhel7.x86_64.rpm | kB :
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : postgresql95-libs-9.5.-2PGDG.rhel7.x86_64 /
Installing : postgresql95-9.5.-2PGDG.rhel7.x86_64 /
Installing : postgresql95-contrib-9.5.-2PGDG.rhel7.x86_64 /
Installing : postgresql95-server-9.5.-2PGDG.rhel7.x86_64 /
Verifying : postgresql95-contrib-9.5.-2PGDG.rhel7.x86_64 /
Verifying : postgresql95-server-9.5.-2PGDG.rhel7.x86_64 /
Verifying : postgresql95-libs-9.5.-2PGDG.rhel7.x86_64 /
Verifying : postgresql95-9.5.-2PGDG.rhel7.x86_64 /

Installed:
postgresql95-contrib.x86_64 :9.5.-2PGDG.rhel7
postgresql95-server.x86_64 :9.5.-2PGDG.rhel7

Dependency Installed:
postgresql95.x86_64 :9.5.-2PGDG.rhel7
postgresql95-libs.x86_64 :9.5.-2PGDG.rhel7

Complete!
　　

3.初始化数据库

[root@localhost ~]# /usr/pgsql-9.5/bin/postgresql95-setup initdb
Initializing database … OK

4.设置开机自启动

[root@localhost ~]# systemctl enable postgresql-9.5
Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-9.5.service to /usr/lib/systemd/system/postgresql-9.5.service.

5.启动服务
[root@localhost ~]# systemctl start postgresql-9.5
[root@localhost ~]# systemctl status postgresql-9.5
● postgresql-9.5.service - PostgreSQL 9.5 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-9.5.service; enabled; vendor preset: disabled)
Active: active (running) since 一 -- :: CST; 49s ago
Process: ExecStart=/usr/pgsql-9.5/bin/pg_ctl start -D ${PGDATA} -s -w -t (code=exited, status=/SUCCESS)
Process: ExecStartPre=/usr/pgsql-9.5/bin/postgresql95-check-db-dir ${PGDATA} (code=exited, status=/SUCCESS)
Main PID: (postgres)
CGroup: /system.slice/postgresql-9.5.service
├─ /usr/pgsql-9.5/bin/postgres -D /var/lib/pgsql/9.5/data
├─ postgres: logger process
├─ postgres: checkpointer process
├─ postgres: writer process
├─ postgres: wal writer process
├─ postgres: autovacuum launcher process
└─ postgres: stats collector process

3月 :: localhost.localdomain systemd[]: Starting PostgreSQL 9.5 da…
3月 :: localhost.localdomain pg_ctl[]: < -- ::27.60…程
3月 :: localhost.localdomain pg_ctl[]: < -- ::27.60….
3月 :: localhost.localdomain systemd[]: Started PostgreSQL 9.5 dat…
Hint: Some lines were ellipsized, use -l to show in full.

//自此，PostgreSQL 9.5 安装完成，此过程中注意安装权限，我在安装过程中一直使用的是root用户进行的安装。

[root@localhost ~]# psql --version
psql (PostgreSQL) 9.5.6

接下来，进行一下简单的配置。

//su postgres  切换用户，执行后提示符会变为 '-bash-4.2$'
[root@localhost ~]# su postgres

//登录数据库，执行后提示符变为
bash-4.2$ psql -U postgres
could not change directory to "/root": Permission denied
psql (9.5.)
Type "help" for help.
//设置postgres用户密码
postgres=# alter user postgres with password 'postgres123'

//退出数据库
postgres-# \q

//系统管理用的帐号和密码变更完成，现在配置一下远程连接 可以参考:http://www.jianshu.com/p/7e95fd0bc91a或者http://www.cnblogs.com/Amos-Turing/p/7681323.html

.开启远程访问
    vi /var/lib/pgsql/9.5/data/postgresql.conf
    修改#listen_addresses = 'localhost'  为  listen_addresses='*'
    当然，此处‘*’也可以改为任何你想开放的服务器IP

//远程连接配置完成，由于系统原因，还需要在防火墙中打开相应的端口。
bash-4.2$ firewall-cmd --list-all
public (active)
target: default
icmp-block-inversion: no
interfaces: wlp4s0
sources:
services: dhcpv6-client ssh
ports:
protocols:
masquerade: no
forward-ports:
sourceports:
icmp-blocks:
rich rules:
//开放postgresql服务
bash-4.2$ firewall-cmd --add-service=postgresql --permanent
success
//重载防火墙
bash-4.2$ firewall-cmd --reload
success
bash-4.2$ firewall-cmd --list-all
public (active)
target: default
icmp-block-inversion: no
interfaces: wlp4s0
sources:
services: dhcpv6-client postgresql ssh
ports:
protocols:
masquerade: no
forward-ports:
sourceports:
icmp-blocks:
rich rules:
//最后一步，不能忘记的，是重启数据库服务，使配置生效。
bash-4.2$ systemctl restart postgresql-9.5.service
bash-4.2$

卸载数据库:

http://www.cnblogs.com/tjpanda88/p/4306149.html4:

http://www.educity.cn/linux/1581284.html

---------------------------------------------------------------------------------------------------------------