Pups::ExecError: su postgres -c 'psql discourse -c "alter schema public owner to discourse;"' נכשל עם החזרה

Try discourse doctor as I don’t seem to be able to help you any further as your just reposting an error. Need to scroll up and look for a cause and verify your app.yml file.

If you perform regular server backups and/or discourse backups you can also recovery that way. but i believe you will loose posts created after the backup.