Ssemaganda Thegaijin

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)

If anyone is interested in setting up their system to automatically (or manually) sign their git commits with their GPG key, here are the steps:

Generate and add your key to GitHub
$ git config --global commit.gpgsign true ([OPTIONAL] every commit will now be signed)
$ git config --global user.signingkey ABCDEF01 (where ABCDEF01 is the fingerprint of the key to use)
$ git config --global alias.logs "log --show-signature" (now available as $ git logs)
$ git config --global alias.cis "commit -S" (optional if global signing is false)
$ echo "Some content" >> example.txt
$ git add example.txt
$ git cis -m "This commit is signed by a GPG key." (regular commit will work if global signing is enabled)

# Ubuntu
sudo apt-get install gpa seahorse
# MacOS with https://brew.sh/

In your command-line run the following commands:

	---
	- hosts: all
	tasks:
	- name: Install prerequisites for Docker repository
	apt:
	name: ['apt-transport-https', 'ca-certificates', 'curl', 'gnupg2', 'software-properties-common']
	update_cache: yes

	- name: Add Docker GPG key
	apt_key: url=https://download.docker.com/linux/ubuntu/gpg


	# enable Docker for your repository
	options:
	docker: true

	pipelines:
	branches:
	development:
	- step:
	# python image with aws-cli installed

	#!/usr/bin/env bash

	touch createstartcript.sh
	if [ "$BITBUCKET_BRANCH" == master ]; then
	export MYENV=$BITBUCKET_BRANCH

	sudo bash -c 'cat > ./createstartcript.sh <<EOF
	#!/usr/bin/env bash

	java -jar FileName-1.0.jar --spring.profiles.active=${MYENV}