...
sudo apt install postgresql libpq-dev
cd /etc/postgresql/9.3/main
sudo cp pg_hba.conf pg_hba.conf.orig
sudo vi pg_hba.conf
sudo cp postgresql.conf postgresqlpostgresq.conf.orig
sudo vi postgresqlpg_hba.conf
sudo -u postgres psql
postgres=# CREATE USER opennsa WITH PASSWORD 'secretpassword';
sudo service postgresql restart
Changes to pg_hba.conf:
...
taas@OpenNSA-dev-13:/etc/postgresql/9.3/main$
...
sudo
...
diff
...
pg_hba.conf
...
pg_hba.conf.
...
orig
90c90
< local all all md5
---
> local all all peer
100,102d99
< # Allow access from remote
< host all all 0.0.0.0/0 trust
<
sudo vi postgresql.conf
Changes to postgresql.conf
(opennsa)taas@OpenNSA-dev-13:/etc/postgresql/9.3/main$ sudo diff postgresql.conf postgresql.conf.orig
59d58
< listen_addresses = '*'
sudo -u postgres psql
postgres=# CREATE USER opennsa WITH PASSWORD 'secretpassword';
sudo service postgresql restart
The DBMS is now polished and ready for creating the databases:
cd /data/opennsa
sudo -u postgres createdb -O opennsa opennsa-ams
sudo -u postgres psql -U opennsa -W opennsa-ams < datafiles/schema.sql
sudo -u postgres createdb -O opennsa opennsa-bra
sudo -u postgres psql -U opennsa -W opennsa-bra < datafiles/schema.sql
sudo -u postgres createdb -O opennsa opennsa-ham
sudo -u postgres psql -U opennsa -W opennsa-ham < datafiles/schema.sql
sudo -u postgres createdb -O opennsa opennsa-lon
sudo -u postgres psql -U opennsa -W opennsa-lon < datafiles/schema.sql
sudo -u postgres createdb -O opennsa opennsa-mad
sudo -u postgres psql -U opennsa -W opennsa-mad < datafiles/schema.sql
sudo -u postgres createdb -O opennsa opennsa-mil
sudo -u postgres psql -U opennsa -W opennsa-mil < datafiles/schema.sql
sudo -u postgres createdb -O opennsa opennsa-par
sudo -u postgres psql -U opennsa -W opennsa-par < datafiles/schema.sql
sudo -u postgres createdb -O opennsa opennsa-prg
sudo -u postgres psql -U opennsa -W opennsa-prg < datafiles/schema.sql
sudo -u postgres createdb -O opennsa opennsa-main
sudo -u postgres psql -U opennsa -W opennsa-main < datafiles/schema.sql
...
Install the latest/current Docker for ubuntu (accoording according to https://www.digitalocean.com/community/tutorials/how-to-install-and-use-docker-on-ubuntu-16-04)
...