postgresql启动不了了
[root@vm7 pgsql]# systemctl status postgresql-10.service
postgresql-10.service - PostgreSQL 10 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-10.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since 五 2019-07-19 23:30:06 CST; 6s ago
Docs: https://www.postgresql.org/docs/10/static/
Process: 5990 ExecStart=/usr/pgsql-10/bin/postmaster -D ${PGDATA} (code=exited, status=203/EXEC)
Process: 5985 ExecStartPre=/usr/pgsql-10/bin/postgresql-10-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
Main PID: 5990 (code=exited, status=203/EXEC)
7月 19 23:30:06 vm7 systemd[1]: Starting PostgreSQL 10 database server...
7月 19 23:30:06 vm7 systemd[1]: postgresql-10.service: main process exited, code=exited, status=203/EXEC
7月 19 23:30:06 vm7 systemd[1]: Failed to start PostgreSQL 10 database server.
7月 19 23:30:06 vm7 systemd[1]: Unit postgresql-10.service entered failed state.
7月 19 23:30:06 vm7 systemd[1]: postgresql-10.service failed.
出现这个问题是环境变量没设置:
su - postgres
vi .bash_profile
改成:
# postgres
PGDATA=/usr/local/pgsql/data
PATH=/usr/local/pgsql/bin:$PATH
export PGDATA PATH
即可解决