环境介绍
- Centos 7
- postgresql 12.0
- gcc 已经安装完毕
一、下载安装
- 下载postgresql相应版本
- https://www.postgresql.org/ftp/source/
- 下载后解压
tar -xvf postgresql-12.0.tar.gz
- 编译,期间报错,安装zlib-devel,readline-devel等,离线安装,gcc 也是必须的
cd postgresql-12.0
./configure
- 安装
make && make install
二、配置用户
1. 添加用户
useradd -s /sbin/nologin -G root pguser
2. 添加用户权限
chmod 775 -R /usr/local/pgsql
三、初始化数据库
su - pguser -c "initdb -D /usr/local/pgsql/data"
四、启动数据库
su pguser
pg_ctl -D /usr/local/pgsql/data
pg_ctl status -D /usr/local/pgsql/data
createdb pguser
五、修改配置
vi /usr/local/pgsql/data/postgresql.conf
# - Connection Settings -
listen_addresses = '0.0.0.0' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
- 关闭防火墙
- 重启服务
pg_ctl restart -D /usr/local/pgsql/data
六、登录测试
pguser$ psql
pguser=# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 12.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit
(1 row)
完成!!!