环境:centos6.6
cat /etc/redhat-release
1.postgresql9.5安装
1.1下载
http://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.6-x86_64/
1.2安装
sudo yum install -y https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6.6-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo yum install -y postgresql95 postgresql95-server
可能会遇到以下报错,解决办法
cd /etc/yum.repos.d
sudo vi pgdg-redhat-all.repo
将里面的https地址改为http,看报错提示可能要改多个
[appadmin@sprtsvr30 kong]$ sudo yum install postgresql95 postgresql95-server
[sudo] password for appadmin:
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-6-x86_64/repodata/repomd.xml:
[Errno 14] problem making ssl connectionTrying other mirror.
1.3初始化
在/etc/profile设置PGDATA环境变量
export PGDATA=/var/lib/pgsql/9.5/data
source /etc/profile
切换到postgres用户(该用户是安装的时候自动创建的,默认密码不知道,自己重设了下密码)下执行以下命令
cd /usr/pgsql-9.5/bin
./initdb
1.4启动
[appadmin@sprtsvr30 home]$ service postgresql-9.5 start
touch: cannot touch `/var/lib/pgsql/9.5/pgstartup.log': Permission denied
[appadmin@sprtsvr30 home]$ sudo service postgresql-9.5 start
1.5创建用户
1.5.1切换到postgres用户,执行psql命令连接数据库
1.5.2创建kong用户
create user kong with password 'kong';
CREATE DATABASE kong OWNER kong;
1.5.3修改密码
\password
1.5.4以kong用户连接
psql -U kong -W
1.5.5退出
\q
1.6配置
vi /var/lib/pgsql/9.5/data/postgresql.conf
将注释去掉
#listen_addresses = 'localhost'
并改为
listen_addresses = '*'
vi /var/lib/pgsql/9.5/data/pg_hba.conf
将host all all 改为127.0.0.1/32改为0.0.0.0/0
# IPv4 local connections:
host all all 127.0.0.1/32 trust
修改之后
host all all 0.0.0.0/0 trust
修改后重启
service postgresql-9.5 restart
2.kong安装
2.1下载
https://bintray.com/kong/kong-rpm/centos/2.1.0#files/centos%2F6
2.2安装
sudo yum -y install kong-2.1.0.el6.amd64.rpm --nogpgcheck
2.3配置
将kong授权给其他用户
cd /usr/local
sudo chmod 777 kong -R
cd /usr/local/bin
sudo chmod 755 kong
cd /usr/local/share/lua/5.1
sudo chmod 777 kong -R
cd /etc
sudo chmod 777 kong -R
2.3.1添加kong用户
[ryan@master kong]$ sudo adduser kong
You have mail in /var/spool/mail/ryan
[ryan@master kong]$ sudo passwd kong
2.3.2修改配置文件
cd /etc/kong
cp sudo cp kong.conf.default kong.conf
sudo chmod 777 kong.conf
vi /etc/kong/kong.conf
admin_listen = 0.0.0.0:8001, 0.0.0.0:8444 ssl
2.4初始化
在kong用户下执行
kong migrations up
kong migrations finish
2.5启动
在kong用户下执行
kong migrations bootstrap
kong start -c /etc/kong/kong.conf --vv
2.4验证
http://192.168.56.102:8001/status
centos7安装
https://blog.csdn.net/cry1049208942/article/details/105971198