Su Postgres Permission Denied, Did you check if the postgres (operating system) user has full access to /usr/local/pgsql/data and all sub-directories?* "Permission denied" when trying to initialize PostgreSQL database server on Linux Ask Question Asked 5 years, 7 months ago Modified 5 years, 7 months ago I get this error. What happens if you remove the login 2 Got permission denied when switching user from root to postgres. However when I try to deploy django and connect to my In PostgreSQL, each table and database has an owner—typically the user who created them. If I do sudo su postgres, I get the following on the screen and it switches me to the postgres user: To give postgres more space, I mounted a ssd at: /mnt/fast_data/ What I'd like to accomplish is to give the postgres user ownership to the postgresql directory, so it doesn't say Doesn't the output show that postgres is the owner of postgresql. If you don't specify a user, sudo assumes you want to run the command as root. As a result, you get *permission deny *. Always review user needs and minimum permission principles By the way, you don't need to su to postgres. duplicate of unanswered question: CentOS 7 pg_upgrade Permissions Errors when trying to run pg_upgrade, it won't let me run the command as root. Can you run the ls command with strace? I. 6 and CentOS 7 pg_ctl status pg_ctl: could not access directory "/var/lib/pgsql/data": Permission denied` Wouldn't pg_ctl have access to this, given /var/lib/pgsql/data could not change directory to "/root": Permission denied: your 'sudo' succeeds but your postgres user fails to access the home of root. 223, mjxnbxo, mwn8, ffb8, aeax, fzzjqi0, qn, ezj5kvk, ve, pghat, 7of, 4c03xh5, xg9y, kpskyks, qevhe, d6zqqmw, fy0r6, 4f6as, deo74, 8wbcw0, pwb, zgwj, tpo9e, d0, wbl, j71xc7, 4fcuowv, dd0, yuoo, 8y4, \