Postgres:comandos

Linhas de comando

Para acessar

psql -u postgres

Ou

su postgres
psql

Listar as database

\l

Selecionar uma database

\c <nome da database>

Lista tabelas da database

\d

Alterar o dono de um database

ALTER DATABASE dvndb OWNER TO dvnapp

DATAVERSE

Database: dvndb
User: dvnapp

Tables

dataverse - Dataverses registrados no base

Instalar o pgadmin

curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add -
sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list' 

sudo apt update
sudo apt install pgadmin4

sudo /usr/pgadmin4/bin/setup-web.sh

= Configurar o Apache

       ProxyPass /pg4 !

       Alias /pgadmin4 /usr/pgadmin4/web/
       WSGIScriptAlias /pg4 /usr/pgadmin4/web/pgAdmin4.wsgi

       WSGIDaemonProcess pg4 user=www-data group=www-data threads=5
       WSGIScriptAlias /pgadmin4 /usr/pgadmin4/web/pgAdmin4.wsgi

       <Directory /usr/pgadmin4/web/>
           WSGIProcessGroup pgadmin
           WSGIApplicationGroup %{GLOBAL}
           Require all granted
           Order deny,allow
           Allow from all
       </Directory>