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