Error: postgresql@11-main.service: PID file /var/run/postgresql/11-main.pid not readable (yet?) after start: No such file or directory
So a few days back i tried to move an odoo database to other machine. For the very first step to accommodate it, I need to install a postgresql to our new server. But once the postgresql are installed successfully, i tried to run it but this is error occured. normal; font-variant-numeric: normal; line-height: normal; margin: 0px;">systemd[1]: postgresql@11-main.service: PID file /var/run/postgresql/11-main.pid not readable (yet?) after start: No such file or directory
 | |
|
I am currently using just postgresql version 11 that doesn't have any other cluster or instance. After checking some logs and figured out why, problem is because the account I am using doesn't have an access to write to /postgresql folder in /var/lib. The solution is you can login using root and type in :
chmod 700 -R /var/lib/postgresql/11/main
You can either use chmod 700 or 775.