linux离线安装postgresql

一、下载和解压

wget https://ftp.postgresql.org/pub/source/v10.18/postgresql-10.18.tar.gz
tar -zxf postgresql-10.18.tar.gz

二、编译

/usr/local/pgsql为安装路径，可自选

cd postgresql-10.18
./configure --prefix=/usr/local/pgsql
make
make install
echo “PG_LIBRARY_PATH=/usr/local/pgsql/lib
PATH=/usr/local/pgsql/bin:$PATH
MANPATH=/usr/local/pgsql/man:$MANPATH
export PATH PG_LIBRARY_PATH MANPATH”>>/etc/profile

安装工具包(apt-cache search 搜索包)
apt-get install libreadline-dev zlib1g-dev
初始化编译环境
apt-get install gcc automake autoconf libtool make

三、创建PG用户

groupadd postgres
useradd postgres -g postgres
mkdir -p /home/postgres
chown -R postgres:postgres /home/postgres
chown -R postgres:postgres /usr/local/pgsql

四、创建数据库集群

su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

五、修改配置信息

修改/usr/local/pgsql/data/postgresql.conf

#listen_addresses = 'localhost'
修改为
listen_addresses = '*'

六、启动和停止数据库服务

/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop

七、注册service服务

cp /opt/postgresql/postgresql-10.18/contrib/start-scripts/linux /etc/init.d/postgresql
chmod 755 /etc/init.d/postgresql

将以下内容添加到/etc/init.d/postgresql开头

### BEGIN INIT INFO
# Provides:          postgresql
# Required-Start:
# Required-Stop:
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: Start postgresql daemon at boot time
# Description:       Start postgresql daemon at boot time
### END INIT INFO

八、设置PG开机自启动

systemctl enable postgresql

九、设置密码访问

修改/usr/local/pgsql/data/pg_hba.conf【IPV4 local connections配置】

host　　all　　all　　127.0.0.1/32　　trust
修改为
host　　all　　all　　0.0.0.0/0　　md5

修改成功后，执行以下命令

/usr/local/pgsql/bin/psql -h localhost -p 5432
ALTER user postgres WITH PASSWORD '1234567'
SELECT pg_reload_conf();