postgresql postgres:数据库是使用归类版本2.35创建得,但操作系统提供得是版本2.36 [已关闭]

siotufzp  于 2022-12-03  发布在  PostgreSQL
关注(0)|答案(1)|浏览(403)

Closed. This question is not about programming or software development . It is not currently accepting answers.

This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers . If you believe the question would be on-topic on another Stack Exchange site , you can leave a comment to explain where the question may be able to be answered.
Closed 8 hours ago.
Improve this question
I want to install openvas in kali an got error when I did this :

sudo runuser -u postgres -- /usr/share/gvm/create-postgresql-database

And this is full error:

The database was created using collation version 2.35, but the operating system provides version 2.36.
[*] Creating permissions
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5433" failed: FATAL:  database "gvmd" does not exist

[*] Applying permissions
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5433" failed: FATAL:  database "gvmd" does not exist
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5433" failed: FATAL:  database "gvmd" does not exist

[*] Creating extension uuid-ossp
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5433" failed: FATAL:  database "gvmd" does not exist
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5433" failed: FATAL:  database "gvmd" does not exist

[*] Creating extension pgcrypto
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5433" failed: FATAL:  database "gvmd" does not exist
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5433" failed: FATAL:  database "gvmd" does not exist

[*] Creating extension pg-gvm
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5433" failed: FATAL:  database "gvmd" does not exist

It seems happens with postgresql 15. I did this before successfully.

4szc88ey

4szc88ey1#

最后,通过清除postgres安装,然后安装postgres解决了问题。

相关问题