Common linux commands

linux_cheat_sheet.txt

############
# SYSTEM
############
# show running daemons (CentOS)
systemctl

# show daemon status (CentOS)
systemctl status sshd.service

############
# NETWORKING
############
ip addr show

############
# POSTGRESQL
############
# login with default user (after fresh install)
sql -U postgres

# to quit session
\q

CREATE USER joe WITH PASSWORD 'password';
CREATE DATABASE joedb WITH OWNER joe;