I'm facing a problem with postgresql, when I try to execute queries with psql I'm getting this kind of error:
psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
the solution I have found on the web is to change access rights for this file:
sudo chmod 777 /var/run/postgresql and to restart postgresql by this command line pg_ctl -D /home/mycomputer/var/postgres/ -l logfile restart
After I log as postgres user sudo su postgres But for now I'm getting this error message: psql: FATAL: role "postgres" does not exist
I have searched on the web and didn't find the good way to solve this.
Could someone help me on this please. thank you in advance