pg_ctl: cannot be runasroot Please login(using, e.g.,"su")asthe (unprivileged) user that will own the server process. 问题原因 用户错误的使用了root用户来执行命令。 --切换到操作系统数据库管理员用户下运行命令 解决方案 1 2 3 [root@db1 root~]# su - highgo [highgo@db1 ~]$ pg_ctl ...
/usr/lib/postgresql/12/bin/pg_ctl /usr/lib/postgresql/12/bin/pg_ctl start -D /var/lib/postgresql/12/main -l /var/log/postgresql/postgresql-12-main.log -s -o -c config_file="/etc/postgresql/12/main/postgresql.conf" exited with status 1: pg_ctl: cannot be run as root Please log...
I get this: | | gridmac7:~ schwarzer$ sudo /opt/local/lib/postgresql82/bin/pg_ctl -D | Documents/data_postgres -l logfile start | pg_ctl: cannot be run as root | Please log in (using, e.g., "su") as the (unprivileged) user that will | own the server process. | | | Wha...
Use saved searches to filter your results more quickly Cancel Create saved search Sign in Sign up Reseting focus {{ message }} gluefinance / postgres Public forked from postgres/postgres-old-soon-decommissioned Notifications You must be signed in to change notification settings Fork 1 ...
$ pg_ctl stop -D /Library/PostgreSQL/9.6/data pg_ctl: could not open PID file "/Library/PostgreSQL/9.6/data/postmaster.pid": Permission denied $ sudo pg_ctl stop -D /Library/PostgreSQL/9.6/data pg_ctl: cannot be run as root $ cd /Library/PostgreSQL/9.6 $ sudo chown -R $(whoami)...
This cannot be any smarter than the existing test in the postmaster, and is most likely to be much stupider. >> How did you get into this state anyway? > Power off on a dev machine ;) Does the dev machine run more than one postmaster? I've occasionally ...
/* PID can be negative for standalone backend */typedeflongpgpid_t; 在第46行代码定义了三种关闭数据库的类型 typedefenum{SMART_MODE,FAST_MODE,IMMEDIATE_MODE}ShutdownMode; 参考文档说的是指定关闭模式.mode可以是smart,fast或immediate,或者这三者之一的第一个字母.如果这被忽略,将使用fast. ...
pg_ctl: cannot be runasroot Please login(using, e.g.,"su")asthe (unprivileged) user that will own the server process. 问题原因 用户错误的使用了root用户来执行命令。 --切换到操作系统数据库管理员用户下运行命令 解决方案 1 2 3 [root@db1 root~]# su - highgo ...
PostgreSQL database-cluster manager — You might be interested in https://github.com/petere/homebrew-postgresql as well. - postgresql-common/pg_ctlcluster at homebrew · petere/postgresql-common