update firmware intel

https://git.kernel.org/pub/scm/linux/kernel/git/firmware/linux-firmware.git/tree/i915

check CPU code (skylake, kabylake ...) and download latest files for each categories.

cd /lib/firmware/i915/

put downloaed files into this.

Reduce laptop overheat

Install TLP and thermald

sudo add-apt-repository ppa:linrunner/tlp
sudo apt-get update sudo apt-get install tlp tlp-rdw
sudo apt-get install thermald



https://itsfoss.com/reduce-overheating-laptops-linux/

Bug cannot detect UTF-8 when ssh deploy (Mac OS)

nano /etc/ssh/ssh_config

comment the line
SendEnv LANG LC_*

Build Citus from source

apt-get install -y libreadline-dev libselinux1-dev libxslt-dev libpam0g-dev git flex make libssl-dev libicu-dev libkrb5-dev libcurl4-gnutls-dev autoconf llvm-7 clang-7

set PG_CONFIG enviroment point to pgsql/bin/pg_config

git clone https://github.com/citusdata/citus.git
cd citus
./configure
make
make install

Add shared_preload_libraries to postgresql.conf

echo "shared_preload_libraries = 'citus'" >> postgres/databaase/postgresql.conf

psql template1
CREATE EXTENSION citus;

Format USB in Ubuntu

View device path e.g (/dev/sda , /dev/sdb ....)
sudo df -h

Replace "/your/device" with usb device path
sudo dd if=/dev/zero of=/your/device bs=1M count=10

Open Disks application, format USB

That's all!

Install .deb package and dependencies

 Example:

wget http://ftp.jp.debian.org/debian/pool/contrib/m/msttcorefonts/ttf-mscorefonts-installer_3.6_all.deb
dpkg -i ttf-mscorefonts-installer_3.6_all.deb
apt -f install
apt install fontconfig

Create read only user on Postgres

GRANT SELECT ON ALL TABLES IN SCHEMA public TO username;

ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON TABLES TO username;