Change owner all database objects to new role

for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" DBNAME` ; do  psql -c "alter table \"$tbl\" owner to NEWUSER" DBNAME ; done

for tbl in `psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" DBNAME` ; do  psql -c "alter table \"$tbl\" owner to NEWUSER" DBNAME ; done

for tbl in `psql -qAt -c "select table_name from information_schema.views where table_schema = 'public';" DBNAME` ; do  psql -c "alter table \"$tbl\" owner to NEWUSER" DBNAME ; done

Kill session on Linux

detect sessions
who

list process id off specified session (ex pts/3 )
ps -dN|grep pts/3

kill processid
kill -9 processid

--
kill all sessions of specified user
skill -KILL -u name_of_user

VirtualBox common command

VBoxManage hostonlyif create
VBoxManage hostonlyif ipconfig vboxnet0 --ip 192.168.56.1
vboxmanage export vmname -o vmname.ova
vboxmanage import vmname.ova

VBoxManage list vms

vboxmanage clonevm "currentmachine" --name NewMachineName --register

VBoxManage startvm "Machine_Name" --type headless

VBoxManage controlvm "Machine_Name" poweroff | reset | savestate

VBoxManage unregistervm "Machine_Name" --delete

Config CPUs:
VBoxManage modifyvm "vm name" --cpuhotplug off
VBoxManage modifyvm "vm name" --cpus 4

Config Memory:
VBoxManage modifyvm "vm name" --memory 16000

sudo VBoxManage extpack install --replace Oracle_VM_VirtualBox_Extension_Pack.vbox-extpack


vboxmanage dhcpserver modify --netname HostInterfaceNetworking-vboxnet0 --disable
vboxmanage list dhcpservers

Change font size eclipse global

Edit file

eclipse\plugins\org.eclipse.ui.themes_1.2.1.v20170809-1435\css\e4_basestyle.css

Add content

* {
font-size: 12px;
}

Change git location on eclipse config

View fileon

/home/user/eclipse/workspaces/workspace1/.metadata/.plugins/org.eclipse.core.runtime/.settings/org.eclipse.egit.core.prefs

Encrypt data postgres

CREATE EXTENSION pgcrypto;

 

SELECT ENCODE(DIGEST('sometext','sha256'),'hex');

 

locale debian

export LANGUAGE=en_US.UTF-8
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
locale-gen en_US.UTF-8
dpkg-reconfigure locales