Wlecome @Lukhanyiso_Bavuma on the opendatakit forum. Do not hesitate to take some time Introduce yourself here! - #1100 by Elena_Rivera
The messages you get tell that psql can't fine the sql file in "D:/odksetup/ODK"
Maybe you forgot to go into D: drive ?
- *D:*
Before launching psql you have to go into the directory. It will be easier than fill the path in the terminal.
When you are in :
- the launch psql
- and then \i create_db_and_user.sql
You can also copy/paste the sql command in psql rather than launch the file.
You have to first create database role, grant user and change database owner (the 4 first line)
And after you have to connect to the new database (\c "database_name";) , create schema and grant user privileges to this schema