01 # PostgreSQL: Tutorial completo de instalação e configuração em Linux

Olá, amigos, nesse vídeo eu mostro como configurar e instalar o banco de dados Postgres no Linux com a distribuição ubuntu. Link da vm com ubuntu zerada: https://drive.google.com/file/d/1WA9z... Abaixo segue o nosso roteiro usado no vídeo. apt install postgresql postgresql-dev unixodbc unixodbc-dev odbc-postgresql -y mkdir -p /postgres/pgdata/bdprd/data /postgres/pgdata/bdprd/index chown -R postgres /postgres passwd postgres cd /postgres su postgres psql -c "alter user postgres with password '1'" -d template1 psql -c "create user bdprd with login nosuperuser inherit createdb nocreaterole noreplication connection limit -1 password 'bdprd'" psql -c "create tablespace bdprd_data owner bdprd location '/postgres/pgdata/bdprd/data'" psql -c "create tablespace bdprd_index owner bdprd location '/postgres/pgdata/bdprd/index'" psql -c "create database bdprd with owner bdprd template = template0 encoding = 'WIN1252' lc_collate = 'C' lc_ctype = 'C' tablespace = bdprd_data connection limit - 1" gedit /etc/odbc.ini [bdprd] Description=PostgreSQL Driver=PostgreSQL ANSI Trace=Yes TraceFile=/tmp/psqlodbc_bdprd.log Servername=127.0.0.1 Database=bdprd UserName=bdprd Password=bdprd Port=5432 ReadOnly=No RowVersioning=No ShowSystemTables=No ShowOidColumn=No FakeOidIndex=No ConnSettings= isql -v bdprd wget https://dbeaver.io/files/dbeaver-ce_l... -O dbeaver-ce.deb && sudo dpkg -i dbeaver-ce.deb