Hoa Mai hoadinhmai

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Once in a while, you may need to cleanup resources (containers, volumes, images, networks) ...

// see: https://github.com/chadoe/docker-cleanup-volumes

$ docker volume rm $(docker volume ls -qf dangling=true)

$ docker volume ls -qf dangling=true | xargs -r docker volume rm

git clone [email protected]:YOUR-USERNAME/YOUR-FORKED-REPO.git

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream

	# remap prefix to Control + a
	set -g prefix C-a
	unbind C-b
	bind C-a send-prefix

	# force a reload of the config file
	unbind r
	bind r source-file ~/.tmux.conf

	# quick pane cycling

	#!/bin/bash
	yum install perl-Switch perl-DateTime perl-Sys-Syslog perl-LWP-Protocol-https -y
	curl http://aws-cloudwatch.s3.amazonaws.com/downloads/CloudWatchMonitoringScripts-1.2.1.zip -O
	unzip CloudWatchMonitoringScripts-1.2.1.zip
	rm CloudWatchMonitoringScripts-1.2.1.zip

	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048