openEuler安装postgresql

yum install -y gcc make readline-devel zlib-devel libicu-devel

cd /usr/local

tar zxvf postgresql-16.0.tar.gz

cd postgresql-16.0

./configure --prefix=/usr/local/postgresql

make -j8 && make install

adduser pgsql

mkdir /usr/local/postgresql/data

chown pgsql /usr/local/postgresql/data

su - pgsql

##初始化数据库/usr/local/postgresql/bin/initdb -D /usr/local/postgresql/data

##启动数据库/usr/local/postgresql/bin/pg_ctl -D /usr/local/postgresql/data -l logfile start

/usr/local/postgresql/bin/psql -d postgres

CREATE USER postgres WITH PASSWORD '123456';ALTER ROLE postgres SUPERUSER;

vi /usr/local/postgresql/data/postgresql.conflisten_addresses = '*'

vi /usr/local/postgresql/data/pg_hba.confhostall all 0.0.0.0/0md5

##重启/usr/local/postgresql/bin/pg_ctl -D /usr/local/postgresql/data -l logfile restart