This is another one of those things I've done all this several times before, but need to keep looking up the documentation.

To login to PostgreSQL after a fresh installation¹ you need to change to the postgres user and run psql (no password needed, it uses Peer Authentication)

sudo …

These are my notes from setting up Gogs on Debian 8 Jessie with Apache2 and PostgreSQL.

This guide assumes you have a fresh copy of Debian Jessie and it's up to date sudo apt-get update && sudo apt-get dist-upgrade && sudo apt-get autoremove.

Firewall

On my server access to all ports except …