Pg-gvm:stable no longer starting

3 hours ago, greenbonebot released v22.6.11 of pg-gvm, which includes Postgres 15 instead of 13 but still states “13” in the config-file. So things are messed up and the container no longer starts. There is already a ticket on github:

2 Likes

Mine says "17”

$ sudo docker compose exec -u gvmd -it gvmd psql --version
psql (PostgreSQL) 17.5 (Debian 17.5-1)

Right now, I got it up and running by re-using the old pg-gvmd that I have, which is 22.6.6

Hi, please pull again. We have re-tagged the pg-gvm 22.6.10 image as stable and latest for now.

Using 22.6.11 uses a newer Debian version as base image and therefore requires to do a postgresql database migration which is not supported at the moment.

2 Likes

I just updated my images and now I’m getting the following errors.

ubuntu@waystar-scanner-0:~$ docker container logs 0d42d6a0496a
/usr/local/bin/start-postgresql: 14: cannot create /etc/postgresql/13/main/pg_hba.conf: Directory nonexistent
/usr/local/bin/start-postgresql: 21: cannot create /etc/postgresql/13/main/pg_hba.conf: Directory nonexistent
Error: specified cluster '13 main' does not exist
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
createuser: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
createdb: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
Error: specified cluster '13 main' does not exist
Error: specified cluster '13 main' does not exist
Deleted verification file.

I’ve deleted volumes, pruned images and containers but nothing seems to work.

I’ve also added: POSTGRES_VERSION=15, but no success. Then I get this error:

ubuntu@infinity-external-scanner-0:~$ docker container logs 96c8036c824a
chmod: cannot access '/var/lib/postgresql/13/main': No such file or directory
/usr/local/bin/start-postgresql: 14: cannot create /etc/postgresql/15/main/pg_hba.conf: Directory nonexistent
/usr/local/bin/start-postgresql: 21: cannot create /etc/postgresql/15/main/pg_hba.conf: Directory nonexistent
Error: specified cluster '15 main' does not exist
psql: error: 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"?
createuser: error: could not connect to database template1: 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"?
psql: error: 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"?
createdb: error: could not connect to database template1: 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"?
psql: error: 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"?
psql: error: 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"?
psql: error: 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"?
psql: error: 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"?
psql: error: 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"?
psql: error: 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"?
psql: error: 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"?
psql: error: 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"?
psql: error: 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"?
Error: specified cluster '15 main' does not exist
Error: specified cluster '15 main' does not exist
Deleted verification file.

Hi @asrozar,

have you tried to pull pg-gvm again? @bricks has re-tagged it as 22.6.10, which still has Postgres 13. If that doesn’t work for you or if stable is again on a newer version with Postgres 15, you have two options.

  1. Use a helper container with Postgres 13 and Postgres 15, and migrate the db to PG15. You have still to use POSTGRES_VERSION=15.
  2. Use the tag 22.6.10 instead of stable, to stick with Postgres 13

Hth Ka-i

Should be fixed (again).

For background see Bug: pg-gvm no longer starting · Issue #97 · greenbone/pg-gvm · GitHub

1 Like

Hi,

Have the same problem with pg-gvm:stable(the same errors), for me works with pg-gvm:22.6.6 and postgres 13

This topic was automatically closed after 90 days. New replies are no longer allowed.