centos7 安装使用postgresql-13

安装

# Install the repository RPM:
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Install PostgreSQL:
sudo yum install -y postgresql13-server

# Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-13/bin/postgresql-13-setup initdb
sudo systemctl enable postgresql-13
sudo systemctl start postgresql-13

修改系统用户postgres密码

passwd postgres

切换postgres用户进入数据库命令行模式

sudo -i -u postgres

修改数据库用户postgresql密码

psql -U postgres
\password
\l

修改数据存储路径

查看存储目录

su postgres
psql -U postgres;
show data_directory;

 创建新存储路径

mkdir /opt/pgsql/data -p

chown -R postgres.postgres /opt/pgsql/data

 初始化

su postgres
/usr/pgsql-13/bin/pg_ctl -D /opt/pgsql/data initdb

 修改配置文件

vi /var/lib/pgsql/13/data/postgresql.conf

data_directory = '/opt/pgsql/data'

 重启服务

systemctl restart postgresql-13

远程连接数据库

vim /var/lib/pgsql/13/data/postgresql.conf

listen_addresses = '*' 

vim /var/lib/pgsql/13/data/pg_hba.conf

host    all             all             0.0.0.0/0               trust