1
docker run -d --name=postgres13 -p 5432:5432 -v /data/postgres-data/postgres13:/var/lib/postgresql/data -e POSTGRES_PASSWORD=qweasd postgres:13.9 -c shared_buffers=2560MB -c max_connections=5000

1
# 最新命令参考: https://www.postgresql.org/download/linux/redhat/
2
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

1
sudo yum
2
install -y postgresql13-server

1
sudo /usr/pgsql-13/bin/postgresql-13-setup initdb

1
sudo systemctl enable postgresql-13
2
sudo systemctl start postgresql-13

1
sudo -u postgres psql postgres
2
could not change directory to "/home/xopsadmin/pipeline": Permission denied
3
psql (13.7)
4
Type "help" for help.
5
# 创建用户
6
postgres=# create user devops with password 'devops';
7
# 创建数据库
8
postgres=# create database vault_db owner devops;
9
# 授权
10
postgres=# grant all privileges on database vault_db  to devops;
11
# 修改管理员密码
12
# ALTER USER postgres WITH PASSWORD 'postgres';
13
# 查看数据库
14
\list