luizomf

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

luizomf

# 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