用户讨论:Jinzd

Kubuntu 技巧

Shell编程基础

man sudo_root

export JAVA_HOME=/usr/local/jdk1.8.0_91/

export PATH=$JAVA_HOME/bin:$PATH

export classPath=/usr/local/jdk1.8.0_91/

Ubuntu

sudo apt-get update

sudo apt-get dist-upgrade / sudo apt-get upgrade
----------------------
sudo apt-get install postresql-9.5

sudo apt-get install pgadmin3

sudo -u postgres psql postgres

\password postgres
----------------------
cd /etc/postgresql/9.5/main

sudo nano postgresql.conf

# add following line to the file

listen_addresses = '*'

# ctrl-o and ctrl-x to finish the operation.

sudo nano pg_hba.conf

# add following line to the file

hostnossl all all 192.168.128.45 255.255.255.0 md5

# ctrl-o and ctrl-x to finish the operation.

ifconfig

ifconfig

Usage:

ifconfig [-a] [-v] [-s] <interface> [[<AF> ] <address>]

[add <address>[/<prefixlen>]]

[del <address>[/<prefixlen>]]

[[-]broadcast [<address>]] [[-]pointopoint [<address>]]

[netmask <address>] [dstaddr <address>] [tunnel <address>]

Java

Add deb resource path:

sudo add-apt-repository "deb http://archive.canonical.com/ubuntu maverick partner"

sudo apt-get update

sudo apt install sun-java8-jdk

# remove

sudo add-apt-repository -r "deb http://archive.canonical.com/ubuntu maverick partner"

PostgreSQL

For newest Ubuntu 16.04 postgresql is ready to install:

jinzd@ubuntu:~S sudo apt install postgresql-9.5

Get postgresql ready to use, set password is the first step:

jinzd@ubuntu:~S sudo -u postgres psql template1

template1=# \password postgres;

or

jinzd@ubuntu:~S sudo -u postgres psql postgres

postgres=# \password postgres;

Create database:

jinzd@ubuntu:~S sudo -u postgres createdb JUniverse

sudo -u postgres psql --host=localhost --username=postgres --password

Create user:

jinzd@ubuntu:~S sudo -u postgres createuser