PostgreSQL ssh

Makefile

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

all:
	make sync
	make restart
	make status

sync:
	scp pg_hba.conf $(SSH_HOSTNAME):/tmp/pg_hba.conf
	scp postgresql.conf $(SSH_HOSTNAME):/tmp/postgresql.conf
	ssh $(SSH_HOSTNAME) sudo cp /tmp/pg_hba.conf /etc/postgresql/$(VERSION)/$(NAME)/pg_hba.conf
	ssh $(SSH_HOSTNAME) sudo cp /tmp/postgresql.conf /etc/postgresql/$(VERSION)/$(NAME)/postgresql.conf

restart:
	ssh $(SSH_HOSTNAME) sudo systemctl restart postgresql.service # sudo systemctl stop postgresql.service

status:
	ssh $(SSH_HOSTNAME) 'service postgresql status | tee';:
	ssh $(SSH_HOSTNAME) 'ps -ax | grep -v grep | grep postgres';:
	ssh $(SSH_HOSTNAME) 'sudo netstat -tulpn | grep :5433';:

ssh.sh

sudo systemctl restart postgresql.service

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