麒麟v10 arm架构安装PostgreSQL

nkvers

############## Kylin Linux Version #################
Release:
Kylin Linux Advanced Server release V10 (Lance)

Kernel:
4.19.90-52.22.v2207.ky10.aarch64

Build:
Kylin Linux Advanced Server
release V10 (SP3) /(Lance)-aarch64-Build23/20230324
#################################################

curl https://ftp.postgresql.org/pub/source/v16.6/postgresql-16.6.tar.gz -o postgresql-16.6.tar.gz

postgres]# tar -zvxf postgresql-16.6.tar.gz

yum install readline.aarch64 readline-devel.aarch64

cd postgresql-16.6/
./configure --prefix=/opt/postgresql --without-readline
make
make install

cd /etc/profile.d/
vim postgresql.sh

export PGHOME=/opt/postgresql
export PGDATA=/opt/postgresql/data
export PATH=$PGHOME/bin:$PATH
export LANG=en_US.utf8
export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH

source postgresql.sh

useradd postgres
mkdir -p /opt/postgresql/data/pgsql
chown postgres:postgres /opt/postgresql/data/pgsql

su - postgres
/opt/postgresql/bin/initdb -D /opt/postgresql/data/pgsql

vim /opt/postgresql/data/pgsql/postgresql.conf

#listen_addresses = 'localhost'

vim /opt/postgresql/data/pgsql/pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     trust
host    replication     all             127.0.0.1/32            trust
host    replication     all             ::1/128                 trust

/opt/postgresql/bin/pg_ctl -D /opt/postgresql/data/pgsql -l logfile start

netstat -anp|grep 5432