一步步带你centos 安装postgresql

# 上传下载的Postgresql的rpm到服务器，然后执行本地安装 yum localinstall -y *.rpm # 找打Postgresql的安装文件 postgresql-setup 什么的 locate setup |grep post # 进入到目录执行 postgresql-setup --initdb # 启动Postgresql systemctl start postgresql # 查看状态 systemctl status postgresql # 连接 su -l postgres # 激活终端 psql # 重置密码 \password # 参考自：https://www.jianshu.com/p/4da8b0405799 # 查看所有用户 \du CREATE USER chaojilaji WITH PASSWORD 'xxxxxx'; CREATE DATABASE spider_xxxxx OWNER chaojilaji; GRANT ALL PRIVILEGES ON DATABASE spider_xxxxxx TO chaojilaji; ALTER USER postgres with password 'xxxxxx'; # 连接 psql -p 5432 -U chaojilaji spider_xxxxxxx # linux上面安装pgAdmin