kong2.0.3+postgresql --centos7，YUM安装记录

• 官网install教程地址

https://docs.konghq.com/install/centos/?_ga=2.40142816.338795781.1587449566-703851507.1587449566#packages

1、安装kong

• 安装kong–yum源

# 方式一，官网
wget https://bintray.com/kong/kong-rpm/rpm -O bintray-kong-kong-rpm.repo
export major_version=`grep -oE '[0-9]+\.[0-9]+' /etc/redhat-release | cut -d "." -f1`
sed -i -e 's/baseurl.*/&\/centos\/'$major_version''/ bintray-kong-kong-rpm.repo
mv bintray-kong-kong-rpm.repo /etc/yum.repos.d/

# 方式二
wget https://bintray.com/kong/kong-rpm/rpm -O /etc/yum.repos.d/bintray-kong-kong-rpm.repo
vi /etc/yum.repos.d/bintray-kong-kong-rpm.repo
    name=bintray--kong-kong-rpm
    baseurl=https://kong.bintray.com/kong-rpm/centos/7
    gpgcheck=0
    repo_gpgcheck=0
    enabled=1
# 清空缓存，重新生成缓存
yum clean all && yum makecache
# 查看yum源信息
yum repolist
# 更新yum源
yum update -y

• 安装kong

yum install -y kong
# 查看配置文件位置
whereis kong
kong: /etc/kong /usr/local/bin/kong /usr/local/kong

2、安装postgresql

• 官方文档

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

• 安装过程

# 安装rpm源
yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# 安装客户端
yum -y install postgresql95
# 安装服务端
yum -y install postgresql95-server
# 初始化数据库
/usr/pgsql-9.5/bin/postgresql95-setup initdb
systemctl enable postgresql-9.5
systemctl start postgresql-9.5

• 登录

su - postgres
psql -U postgres
ALTER USER postgres with encrypted password 'brains1234';
# 退出
\q
exit

• 配置远程连接

vi /var/lib/pgsql/9.5/data/postgresql.conf
    listen_addresses = '*'
vi /var/lib/pgsql/9.5/data/pg_hba.conf 
    # IPv4 local connections:
    host    all             all             127.0.0.1/32            ident
    host    all             all             0.0.0.0/0               md5
systemctl restart postgresql-9.5

3、kong配置postgresql数据库

• 创建用户

su - postgres
psql -U postgres
 CREATE USER kong; 
 CREATE DATABASE kong OWNER kong;
 ALTER USER kong with encrypted password 'kong';  

• kong,postgresql连接配置

cp -r /etc/kong/kong.conf.default /etc/kong/kong.conf
vi /etc/kong/kong.conf
    database = postgres
    pg_host = 172.28.102.62
    pg_port = 5432
    pg_timeout = 5000

    pg_user = kong
    pg_password = kong
    pg_database = kong
    
# 初始化数据库
kong migrations bootstrap [-c /etc/kong/kong.conf]
# 启动kong
kong start [-c /etc/to/kong.conf]