Heroku apps have random port assigned - see this question on Stackoverflow.
Also - PG needs to be version 11, I haven’t figured proper settings in heroku.yml so I provison it manually (one time job) with following command:
heroku addons:create heroku-postgresql:hobby-dev --version=11 -a my-app
Here is my heroku.yml:
setup:
#addons:
# - plan: heroku-postgresql:hobby-dev
# version: 11
# as: DATABASE
config:
SUBDOMAIN: "my-app"
DOMAIN_NAME: "herokuapp.com"
NODE_ENV: "production"
TZ: "Europe/Berlin"
GENERIC_TIMEZONE: "Europe/Berlin"
N8N_HOST: "${SUBDOMAIN}.${DOMAIN_NAME}"
N8N_PORT: "${PORT}"
N8N_PROTOCOL: "https"
N8N_ENCRYPTION_KEY: "mysupersecretkey"
WEBHOOK_TUNNEL_URL: "https://${SUBDOMAIN}.${DOMAIN_NAME}/"
VUE_APP_URL_BASE_API: "https://${SUBDOMAIN}.${DOMAIN_NAME}/"
DB_TYPE: "postgresdb"
DB_POSTGRESDB_HOST: "dbhost"
DB_POSTGRESDB_DATABASE: "dbname"
DB_POSTGRESDB_PORT: 5432
DB_POSTGRESDB_USER: "dbuser"
DB_POSTGRESDB_PASSWORD: "dbpass"
build:
docker:
web: Dockerfile
Command
heroku logs --tail
returns
2020-04-15T11:19:50.178271+00:00 app[web.1]: [WARN tini (3)] Tini is not running as PID 1 and isn't registered as a child subreaper.
2020-04-15T11:19:50.178300+00:00 app[web.1]: Zombie processes will not be re-parented to Tini, so zombie reaping won't work.
2020-04-15T11:19:50.178302+00:00 app[web.1]: To fix the problem, use the -s option or set the environment variable TINI_SUBREAPER to register Tini as a child subreaper, or run Tini as PID 1.
2020-04-15T11:19:50.179480+00:00 app[web.1]: su-exec: setgroups: Operation not permitted
2020-04-15T11:24:54.478493+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/" host=my-app.herokuapp.com request_id=myid fwd="myip" dyno= connect= service= status=503 bytes= protocol=https