一、初始化数据库的命令

#!/bin/bash

adduser postgres

PGHOME="/opt/common/postgresql" # PostgreSQL 命令的位置
datadir="/opt/data/pgdata-13.1" # 数据库文件的位置，在执行这个脚本前，这个目录必须不存在
mkdir -p ${datadir} # 创建目录结构

chown postgres:postgres ${datadir} -R

su - postgres -c "${PGHOME}/bin/initdb -D ${datadir} -E UTF8 --locale=C -U postgres" # 初始化数据库文件

su - postgres -c "${PGHOME}/bin/pg_ctl -D ${datadir} start" # 启动数据库

password=$(cat /proc/sys/kernel/random/uuid) # 生成一个随机密码
${PGHOME}/bin/psql -U postgres -h 127.0.0.1 -c "alter role postgres with password '${password}'" # 把数据库用户 postgres 的密码改为刚刚生成的随机密码

psql -U postgres -h 127.0.0.1 -p 5432 -c "create database dogdb with template = template0 ENCODING = UTF8" # 创建一个名为 dogdb 的数据库

echo "pg user postgres, password [${password}]" # 输出这个数据库密码

二、执行脚本，生成数据库文件

$ ./init-db.sh 
adduser: user 'postgres' already exists
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /opt/data/pgdata-13.1 ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    /opt/common/postgresql/bin/pg_ctl -D /opt/data/pgdata-13.1 -l logfile start

waiting for server to start....2021-03-23 03:50:39.694 UTC [13712] LOG:  starting PostgreSQL 13.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
2021-03-23 03:50:39.695 UTC [13712] LOG:  listening on IPv6 address "::1", port 5432
2021-03-23 03:50:39.695 UTC [13712] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2021-03-23 03:50:39.702 UTC [13712] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2021-03-23 03:50:39.710 UTC [13713] LOG:  database system was shut down at 2021-03-23 03:50:39 UTC
2021-03-23 03:50:39.716 UTC [13712] LOG:  database system is ready to accept connections
 done
server started
ALTER ROLE
CREATE DATABASE
pg user postgres, password [422fcc44-c85d-44ba-aa16-d899ac59e9b3]

从输出的信息可以看出，创建数据库成功，并且随机密码是：422fcc44-c85d-44ba-aa16-d899ac59e9b3

查看数据库创建结果：

$ /opt/common/postgresql/bin/psql -h 127.0.0.1 -U postgres -c "\l"
                             List of databases
   Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges   
-----------+----------+----------+---------+-------+-----------------------
 dogdb     | postgres | UTF8     | C       | C     | 
 postgres  | postgres | UTF8     | C       | C     | 
 template0 | postgres | UTF8     | C       | C     | =c/postgres          +
           |          |          |         |       | postgres=CTc/postgres
 template1 | postgres | UTF8     | C       | C     | =c/postgres          +
           |          |          |         |       | postgres=CTc/postgres
(4 rows)

可以看到 dogdb 已经创建成功。

---