Search code examples
postgresqlsudosu

Can't run postgres on my system. It's showing `postgres is not in the sudoers file. This incident will be reported.`

I'm trying to install postgres on my WSL Ubuntu. Installation is finished but when I run psql the following error is displayed.

psql: error: could not connect to server: 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"?

And when I run sudo find /var/run/postgresql/.s.PGSQL.5432 to find the file, it's showing another error like this.

postgres is not in the sudoers file. This incident will be reported.

It'll be more clear from the screenshot.

How to continue? Please help...

Screenshot:

reference

Solution

  • This error seems to be because your username, i.e postgres is not in the sudoers file. Which is why you don't have authority to run the above command for the postgres user.

    Try adding the user by:

    Open file

    sudo nano /etc/sudoers

    Then add the user below admin user like below syntax.

    user_name ALL=(ALL)  ALL