aaronbronow

apt list --installed | sed -E 's/^(.*)\/.*/\1/'

aaronbronow

gitlab-rake gitlab:backup:create
tar cfz /secret/gitlab/backups/$(date "+etc-gitlab-\%s.tgz") -C / etc/gitlab

aaronbronow

for i in $(docker images -q)
do
    docker history $i | grep -q $IMG && echo $i
done | sort -u

aaronbronow

JOIN

SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;

aaronbronow

Use the commands below to set privileges using the PSQL terminal commands.  

TABLES:
for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" YOUR_DB` ; do  psql -c "alter table $tbl owner to NEW_OWNER" YOUR_DB ; done

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

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

aaronbronow

USER_EMAIL=aaron@aaronbronow.com
echo "Setting up your Ubuntu tools..."

wget -O ~/.bash_profile https://gist.githubusercontent.com/aaronbronow/17c442af81cb4e746b7cc95974f8a8cf/raw
source ~/.bash_profile

sudo apt-get --yes update
sudo apt-get --yes install vim git-core tig curl tmux openvpn

# setup vim

aaronbronow

docker run -d --name socks5-proxy -p 443:1080 -e PROXY_USER=aaron -e PROXY_PASSWORD=password serjs/go-socks5-proxy

aaronbronow

dig +short myip.opendns.com @resolver1.opendns.com.

aaronbronow

### Thanks, ingy.net for this one that has no special package requirements
cat /dev/urandom | LC_CTYPE=C tr -cd a-zA-Z0-9+/ | fold -w12 | head -1

# or

openssl rand -base64 12

aaronbronow

0x43a1aa25aA535958dc1cD2E7A59A97B44174fb0D