SUSE Linux Enterprise Server 12SP5 (PostgreSQL) 10.12
SUSE Linux Enterprise Server 12SP3 (PostgreSQL) 10.8
linux-137:/usr/local # zypper install postgresql-server postgresql
linux-137:/usr/local # psql --version
psql (PostgreSQL) 10.12
linux-137:/home # chown postgres:postgres ./psqldata/
linux-137:/home # su postgres
postgres@linux-137:/home> initdb -D /home/psqldata/
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 locales
COLLATE: C
CTYPE: en_US.UTF-8
MESSAGES: C
MONETARY: C
NUMERIC: C
TIME: C
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /home/psqldata ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default timezone ... Asia/Shanghai
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
postgres@linux-137:/home> pg_ctl -D /home/psqldata/ start
waiting for server to start....2020-10-13 21:00:44.354 CST [15250]LOG: listening on IPv6 address "::1", port 5432
2020-10-13 21:00:44.355 CST [15250]LOG: listening on IPv4 address "127.0.0.1", port 5432
2020-10-13 21:00:44.359 CST [15250]LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-10-13 21:00:44.373 CST [15250]LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
2020-10-13 21:00:44.387 CST [15250]LOG: redirecting log output to logging collector process
2020-10-13 21:00:44.387 CST [15250]HINT: Future log output will appear in directory "log".
done
server started
后台运行的命令 postgres -D /usr/local/pgsql/data >logfile 2>&1 &
还是以下命令来的省事
systemctl start postgresql.service
systemctl enable postgresql.service
服务目录：/usr/lib/systemd/system
创建数据库及用户
psql postgres
create user pub password 'test001';
create database pgsql1 owner pub;