Server side commands

usefull commands

# Change ssh port
sudo vi /etc/ssh/sshd_config
port 22
sudo service ssh restart

# Language problem solution
sudo vi /etc/environment
LC_ALL="en_US.utf8"
LANGUAGE="en_US.utf8"
sudo dpkg-reconfigure locales

# After language problem you should create postgresql cluster
pg_createcluster 9.3 main --start
/etc/init.d/postgresql start


# Install Redis Server
sudo apt-get -y install redis-server
sudo service redis-server status
sudo netstat -naptu

# Find command
find /home/deploy/ -type d -name "*searched_text*" -print

# Scp remote to local 
scp -P 22 -r [email protected]:/home/root/file.txt /Users/user/Desktop

# Postgresql db import
psql database_name < PostgreSQL.sql
pg_dumpall -f PostgreSQL.sql
psql -f PostgreSQL.sql postgres

# On psql terminal
drop schema public cascade;
create schema public;