Dataverse:Postgress

Estrutura da tabela

Dataverse:Postgtess-Tables

Postgresql

apt install postgresql
pico /etc/postgresql/14/main/postgresql.conf 

Alterar a linha

#listen_addresses = 'localhost' 
    para 
listen_addresses = '*' libera para todas as conexões
port = 5432

nano /etc/postgresql/12/main/pg_hba.conf

Troque

host    all             all             127.0.0.1/32            md5
host    all             all             ::1/128                 md5

por

host    all             all             127.0.0.1/32            trust
host    all             all             ::1/128                 trust

service postgresql restart

Para testar o funcionando do POSTGRES

/usr/bin/psql -h localhost -p 5432 -U postgres -d postgres -c 'SELECT * FROM pg_roles'

Excluíndo dvndb database no Dataverse

su postgres
psql
drop database dvndb;
quit;

Install unzip

apt-get install unzip