Install Build-Essential JDK (Ubuntu)

sudo apt-get update

sudo apt-get upgrade

sudo apt-get install build-essential

Install Oracle JDK (Ubuntu)

sudo apt-add-repository ppa:webupd8team/java

sudo apt-get update

sudo apt-get install -y oracle-java8-installer

export JAVA_HOME=/usr/lib/jvm/java-8-oracle

Install sbt (Ubuntu)

echo "deb https://dl.bintray.com/sbt/debian /" | sudo tee -a /etc/apt/sources.list.d/sbt.list

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 642AC823

sudo apt-get update

sudo apt-get install sbt

Tomcat Configuration

tomcat-users.xml: < role rolename="manager-gui"/> < user username="admin" password="admin" roles="manager-gui"/>

Maven Install

mvn clean install -U dependency:copy-dependencies

Postgresql Install/Uninstall (9.6)

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'

wget -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O - | sudo apt-key add -

sudo apt-get update

sudo apt-get install postgresql postgresql-contrib

sudo su - postgres

psql

postgres=# \conninfo

sudo apt-get --purge remove postgresql\*

Postgresql Configuration

ps -fu postgres

/etc/postgresql/9.6/main/pg_hba.conf

service postgresql-9.5 status

service postgresql-9.5 restart

/etc/init.d/postgresql restart

netstat -nptl

ps -ef | grep postgres

\connect postgis

SELECT schema_name FROM information_schema.schemata;

SELECT table_name FROM information_schema.tables WHERE table_schema='public';

SHOW config_file;

Postgis Install/Uninstall

sudo apt-get install postgis

sudo -u postgres psql

CREATE DATABASE postgis;

CREATE EXTENSION postgis;

CREATE EXTENSION postgis_topology;

Postgresql Command

\i input.sql

psql -d postgis --set ON_ERROR_STOP=on -f input.sql

SET search_path TO myschema,public;

Useful Command

copy *.txt total.txt

cat *.txt >> total.txt

Configuration Files

/etc/postgresql/9.6/main/pg_hba.conf

/usr/pgsql-9.5/bin

/var/lib/pgsql/9.5/data/pg_hba.conf

Linux Configuration

/etc/sysconfig/iptables

/etc/init.d/iptables restart

sudo -u postgres psql postgres

Network

nmap -p 80 xxx.xxx.xxx.xxx

Ubuntu Command

nohup command &

Postgres Command

pg_dump -U postgres -d fdot_pams -n mvds > mvds.dmp

\i mvds.dmp

Vacuum all databases, perform full vacuuming, aggressively “freeze” tuples, and calculate statistics for use by the optimizer.

vacuumdb -U postgres -a -f -F -z

VACUUM FULL FREEZE VERBOSE ANALYZE;

CREATE INDEX vehicle_data_id_idx ON logbook.vehicle_data USING btree(id);

CLUSTER logbook.vehicle_data USING vehicle_data_id_idx;

Tomcat Server Kill

sudo netstat -plten |grep java