Andrew P andrewp-as-is

## docker-stop-all-containers.sh
sudo docker ps -q | xargs -r sudo docker stop

## macOS-list-ports.sh
#!/usr/bin/env bash

PORT=8013
lsof -nP -iTCP:$PORT | grep LISTEN;:

## gunicorn-kill-processes.sh
#!/usr/bin/env bash

ps aux | grep gunicorn | awk '{print $2;}' | xargs kill -9 2>/dev/null
ps aux | grep gunicorn | awk '{print $2;}' | xargs kill -9 2>/dev/null
ps aux | grep gunicorn | awk '{print $2;}' | xargs kill -9 2>/dev/null

ps aux | grep python | awk '{print $2;}' | xargs kill -9 2>/dev/null


## certbot.sh
sudo certbot --nginx certonly -d domain.com,www.domain.com --expand

## user.sql
--sudo -u postgres psql -p 5432
CREATE USER username WITH PASSWORD 'secret';
ALTER USER username WITH PASSWORD 'secret';
DROP USER username;
CREATE DATABASE dbname WITH OWNER=username;
GRANT ALL PRIVILEGES ON DATABASE "dbname" to username;

## postgres-status.sh
service postgresql status | tee
sudo pg_lsclusters
ps -ax | grep -v grep | grep postgres
sudo netstat -tulpn | grep :543

## Makefile
SSH_HOSTNAME:=ubuntu@github42
NAME:=github42
VERSION:=12

all:
	make sync
	make restart
	make status

sync:

## postgres-logs.sh
sudo find /var/log/postgresql -name '*.log'
sudo find /var/log/postgresql -name '*.log' -exec rm {} \;

## Makefile
SSH_HOSTNAME:=ubuntu@github42
NAME:=github42
VERSION:=12

all:
	make sync
	make restart
	make status

sync:

## docker-exec.sh

sudo docker exec -it "$(sudo docker ps -qf name=NAME)" sh
	#!/usr/bin/env bash

	PORT=8013
	lsof -nP -iTCP:$PORT \| grep LISTEN;:
	#!/usr/bin/env bash

	ps aux \| grep gunicorn \| awk '{print $2;}' \| xargs kill -9 2>/dev/null
	ps aux \| grep gunicorn \| awk '{print $2;}' \| xargs kill -9 2>/dev/null
	ps aux \| grep gunicorn \| awk '{print $2;}' \| xargs kill -9 2>/dev/null

	ps aux \| grep python \| awk '{print $2;}' \| xargs kill -9 2>/dev/null
	--sudo -u postgres psql -p 5432
	CREATE USER username WITH PASSWORD 'secret';
	ALTER USER username WITH PASSWORD 'secret';
	DROP USER username;
	CREATE DATABASE dbname WITH OWNER=username;
	GRANT ALL PRIVILEGES ON DATABASE "dbname" to username;
	service postgresql status \| tee
	sudo pg_lsclusters
	ps -ax \| grep -v grep \| grep postgres
	sudo netstat -tulpn \| grep :543
	SSH_HOSTNAME:=ubuntu@github42
	NAME:=github42
	VERSION:=12

	all:
	make sync
	make restart
	make status

	sync:
	sudo find /var/log/postgresql -name '*.log'
	sudo find /var/log/postgresql -name '*.log' -exec rm {} \;