Pups::ExecError: su postgres -c ‘psql discourse -c “alter schema public owner to discourse;”’ failed with return #<Process::Status: pid 54 exit 2>
ata directory “/shared/postgres_data” has invalid permissions
my app.yml file
## Plugins go here ## see https://meta.discourse.org/t/19157 for deta$hooks: after_code: - exec: cd: $home/plugins cmd: - git clone https://github.com/discourse$ - git clone https://github.com/Ebsy/disc$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$ - git clone https://github.com/davidtayl$ - git clone https://github.com/discourse$## - git clone https://github.com/pavilio$## Official Plugins ## - git clone https://github.com/discour$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$ - git clone https://github.com/discourse$## New Pluguns installed - git clone https://github.com/Ahmedgaga$## - git clone https://github.com/gdpelic$ - git clone https://github.com/paviliond$## Any custom commands to run after building
run: - exec: echo "Beginning of custom commands" ## If you want to set the 'From' email address f$ ## After getting the first signup email, re-comm$ #- exec: rails r "SiteSetting.notification_email$ - exec: echo "End of custom commands"copy and paste this to see if any fornmatting errors.
Not sure how to wrap it so it lists…
2023-02-11 19:55:35.034 GMT [42] LOG: skipping missing configuration file “/shared/postgres_data/postgresql.auto.conf”
2023-02-11 19:55:35.035 UTC [42] FATAL: could not read permissions of directory “/shared/postgres_data”: Permission denied
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.
Hi Ratnam,
Perhaps it would be a good idea to explain what you’re trying to achieve and what software you use because it’s a bit confusing right now. You’re mostly posting error messages without the proper context to fully understand.
Please first reply to these questions and we’ll try moving forward starting from here 
-
Are you trying to install a production Discourse using the regular docker install, following the steps described here discourse/INSTALL-cloud.md at main · discourse/discourse · GitHub?
-
What is your operating system?
-
What are your server specs?
2 Likes
This looks like the problem, though I cannot imagine how changing the plugins would have caused an issue with the postgres permissions. Have you changed something else? This is a standard install, right?
safe-mode will not help since the site isn’t working.
2 Likes
I solved the issue by changing postgres data permissions @Canapin @Heliosurge Thanks for your support
3 Likes
I used following slack
GitHub - discourse/discourse_docker: A Docker image for Discourse /var/discoursed
Operating System - ubuntu 20.04 LTS
Server - 8GB RAM 30GB
Thanks & Regards
1 Like
Congrats. Glad you got it tesolved. I would recommend maybe doing a server backup if your thinking on trying a plugin install.
Though tbh you should be fine as long as you enter the plugin install correctly. With the plugin you were trying to install now come to think of it may need an update. Iirc now it showed last activity was feb 2022? if so it is potentially a year out of date and changes since then mau have broken the plugin.
Confirmed
I would recommend looking over plugin Category and see if any plugins may peak your interest.
Discourse Reactions
- Is pretty cool as it gives you a way to extend to beyond simple likes.
National Flags
- Gives your members option to display a flag on there posts.
Discourse Docs
- Great for setting up a knowledge base seach. Good companion to Solved.
Discourse Solved
- Setup a category for users t9 ask a question. Op Can choose best solution that worked. good to set category to always display first post. Solution is quoted in the Op’s post snd marked solved. There is a theme-component to make solvef quote prettier.
Discourse Who’s Online
- Shows on different pages who is online. if User online if your reading a post a glow circle will surround profile pic.
Discourse Templates
- Create template replies aka ‘canned replies’. Too much to much to mention. See topic
Main thing avoid deprecated and end of life plugins. You want plugins that have activeb maintainers. Good ones of Note are Disvourse Official plugins and Pavilion group; though there are many others that are actively maintained then just these 2 groups I have mentioned.
1 Like