yum -y install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-centos96-9.6-3.noarch.rpm

 yum -y install postgresql96-9.6.7

yum -y install postgresql96-server-9.6.7


service postgresql-9.6 initdb

chkconfig postgresql-9.6 on

service postgresql-9.6 start


登录


su - postgres

psql

查看库

\l；

创建库

create database abc;

切换库：\c  abc;

查看表

\d;