PostgreSQL Errors

  1. When starting Postgresql on Ubuntu ( Windows Subsystem), there might be an error that says: data directory "/var/lib/posgresql/10/main has a group or world access. This is not advisable because of the folder containing the data should be secure.

    Solution:

    This command: sudo chmod 700 -R /var/lib/postgresql/10/main
    Then: sudo service postgresql start (this command starts the postgresql database engine)