centos7安装postgres-10

yum install pgdg-centos10-10-2.noarch.rpm

yum install -y postgresql10-server postgresql10

/usr/pgsql-10/bin/postgresql-10-setup initdb

systemctl start postgresql-10

[root@localhost system]# netstat -antup | grep 5432
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      2753/postmaster

 systemctl enable postgresql-10

 systemctl stop postgresql-10

cp -R /var/lib/pgsql/10/ /data/postgres/db/
chown -R postgres.postgres   /data/postgres/db/

vim /var/lib/pgsql/.bash_profile
设置
PGDATA=/data/postgres/db/10/data

vim /usr/lib/systemd/system/postgresql-10.service
设置
Environment=PGDATA=/data/postgres/db/10/data

systemctl daemon-reload
systemctl start postgresql-10

su postgres
psql

\password

cd /data/postgres/db/10/data

# IPv4 local connections:
host    all             all             127.0.0.1/32            ident
host    all             all             10.7.10.1/24           md5

listen_addresses = '*'          # what IP address(es) to listen on;
                                        # comma-separated list of addresses;
                                        # defaults to 'localhost'; use '*' for all
                                        # (change requires restart)
#port = 5432                            # (change requires restart)
max_connections = 2000                  # (change requires restart)

systemctl start postgresql-10

export PGPASSWORD='123456'
psql -Upostgres  -h10.7.10.111

postgres=# show max_connections;
 max_connections 
-----------------
 2000
(1 row)