Fabrício Cruz Mendes FabricioCruzDev

## create-self-signed-ssl-certificates.sh
cd /var/lib/postgresql/13/main

# Create a self-signed certificate
openssl req -new -nodes -text -out server.csr \
  -keyout server.key -subj "/CN=postgresql.otaviomiranda.com.br"

openssl x509 -req -in server.csr -text -days 3650 \
  -extfile /etc/ssl/openssl.cnf -extensions v3_ca \
  -signkey server.key -out server.crt

## postgresql_13_pgadmin_4_ubuntu_20_04.sh
# Update all your packages
sudo apt update
sudo apt upgrade -y

# Add postgresql repository and key
sudo sh -c 'echo "deb [arch=$(dpkg --print-architecture)] http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

# Update again
	cd /var/lib/postgresql/13/main

	# Create a self-signed certificate
	openssl req -new -nodes -text -out server.csr \
	-keyout server.key -subj "/CN=postgresql.otaviomiranda.com.br"

	openssl x509 -req -in server.csr -text -days 3650 \
	-extfile /etc/ssl/openssl.cnf -extensions v3_ca \
	-signkey server.key -out server.crt
	# Update all your packages
	sudo apt update
	sudo apt upgrade -y

	# Add postgresql repository and key
	sudo sh -c 'echo "deb [arch=$(dpkg --print-architecture)] http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

	wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc \| sudo apt-key add -

	# Update again