Problem with fresh installation (Debian 10)

Your main issue is this:

The installation does not complete successfully.
Ensure that your postgresql server is running and working.

If it doesn’t, check it’s logfiles on why it doesn’t want to start or talk to Zammad.

If you fixed that issue, run /opt/zammad/contrib/packager.io/postinstall.sh again to ensure the installation finished successfully.