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;

pgAdmin 4 bug when install Python 3

pgAdmin 4 has bug table_oid on query check it https://stackoverflow.com/questions/57226520/select-does-not-return-values-postgres-11-4

insufficient permissions for device

retrieving device properties for ro.product.cpu.abi:
error: insufficient permissions for device: user in plugdev group; are your udev rules wrong?

--> change Charge devic to PTP on USB config of Phone

Remove watermark pdf

pdftops in.pdf - | sed 's/WATERMARK//' | ps2pdf - out.pdf

Oracl basics

source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh

/etc/init.d/oracle-xe start

/etc/init.d/oracle-xe stop

sqlplus / as sysdba