chrisnyc
commented
2 years ago I solved the problem by manually installing postgresql first with the following commands. Note that I added the postgresql-client. I'm not sure if that helped or not.
apt-get -y install postgresql postgresql-contrib postgresql-server-dev-all postgresql-client
systemctl enable postgresql
systemctl start postgresql
Next, I waited a minute, and then ran
systemctl status postgresql
The output should look like this:
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Fri 2022-04-15 16:09:22 EDT; 25s ago
Main PID: 13944 (code=exited, status=0/SUCCESS)
Tasks: 0 (limit: 4696)
Memory: 0B
CGroup: /system.slice/postgresql.service
Apr 15 16:09:22 dev-int-ovas systemd[1]: Starting PostgreSQL RDBMS...
Apr 15 16:09:22 dev-int-ovas systemd[1]: Finished PostgreSQL RDBMS.Then I commented out the installation steps on the lines 112,113 and 120,121 of install_gvm.sh like this:
#apt-get -y install postgresql postgresql-contrib postgresql-server-dev-all
#systemctl restart postgresql
sudo -Hiu postgres createuser gvm
sudo -Hiu postgres createdb -O gvm gvmd
sudo -Hiu postgres psql -c 'create role dba with superuser noinherit;' gvmd
sudo -Hiu postgres psql -c 'grant dba to gvm;' gvmd
sudo -Hiu postgres psql -c 'create extension "uuid-ossp";' gvmd
sudo -Hiu postgres psql -c 'create extension "pgcrypto";' gvmd
#systemctl restart postgresql
#systemctl enable postgresqlFinally, I ran
sudo ./install_gvm.sh -v 21 -u
per the regular procedure.
The output of the postgres commands above should look like this:
CREATE ROLE
GRANT ROLE
CREATE EXTENSION
CREATE EXTENSIONThanks very much for this script! It's very helpful!
yu210148
Hi, so installing v21 on Ubuntu 20.04 on GCP.
Seems the postgresql setup failed. I think this is because I'm using a low-spec e2-medium VM in GCP and with everything else going on in the script, the machine is bogged down at this point. Below are the logs showing the failures: