我更新了我的Xubunutu,当我在这个labtop上安装的时候,它原来是19.04,我想我以前做过一次更新,现在是Xubuntu 19.10。
Postgres在升级之前正在运行,我想我可能运行了两个版本的postgres,但我看到的许多解决方案似乎都不起作用。
当我键入: service postgresql status时
我得到了
postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor prese
Active: active (exited) since Mon 2019-12-09 07:33:43 EST; 4h 30min ago
Main PID: 1217 (code=exited, status=0/SUCCESS)
Tasks: 0 (limit: 4915)
Memory: 0B
CGroup: /system.slice/postgresql.service
Dec 09 07:33:43 alexmerced-X550EA systemd[1]: Starting PostgreSQL RDBMS...
Dec 09 07:33:43 alexmerced-X550EA systemd[1]: Started PostgreSQL RDBMS.
lines 1-10/10 (END)
当我键入: dpkg -l | grep postgres
我得到了:
ii postgresql 11+204ubuntu0.1 all object-relational SQL database (supported version)
ii postgresql-11 11.5-1 amd64 object-relational SQL database, version 11 server
ii postgresql-client-11 11.5-1 amd64 front-end programs for PostgreSQL 11
ii postgresql-client-common 204ubuntu0.1 all manager for multiple PostgreSQL client versions
ii postgresql-common 204ubuntu0.1 all PostgreSQL database-cluster manager
当我输入: pg_lsclusters
我得到了:
pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
11 main 5432 down postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
以防万一: psql -h /tmp
psql -h /tmp
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
sudo service postgres restart
Failed to restart postgres.service: Unit postgres.service not found.
ps aux |grep postgres
alexmer+ 26272 0.0 0.0 9028 916 pts/2 S+ 12:11 0:00 grep --color=auto postgres
发布于 2019-12-10 01:41:34
修复方法是卸载OP中dpkg结果中的所有包,然后使用sudo apt-get install postgresql重新安装。
现在重新配置我的用户
https://stackoverflow.com/questions/59253613
复制相似问题