Can not perform init using PostgreSQL non-superuser account

[RUAN0007]

For a non-superuser account, I can configure it using orpheus config.

machine@machine-HP-Pavilion-15-Notebook-PC:~/Desktop/implementation$ orpheus whoami
Logged to the database [exampledb] as [dbuser]

However, when i am performing the example init query, the following error occurs.

machine@machine-HP-Pavilion-15-Notebook-PC:~/Desktop/implementation$ orpheus init test/data.csv dataset2 -s test/sample_schema.csv
Connecting to the database [exampledb] ...
Creating the dataset [dataset2] to the database [exampledb] ...
Creating the data table using the schema provided ...
Creating the version table ...
Creating the index table ...
Operation failure, check system parameters

It seems the dataset is not successfully created.

machine@machine-HP-Pavilion-15-Notebook-PC:~/Desktop/implementation$ orpheus ls
Connecting to the database [exampledb] ...
The current database contains the following CVDs:

No dataset has been initialized before, try init first

[liqixu]

@RUAN0007 Thanks again for bringing up the issue. However, I could not reproduce it. I assumed your Postgres username [dbuser] was created without using OrpheusDB, was that correct? Also, does [dbuser] has CREATE privilege?

[RUAN0007]

Yes, I created [dbuser] without using OrpheusDB but using the first method introduced in this link. I think i have granted all privileges to that user.

[liqixu]

Did you install the Postgres on your own laptop. Otherwise, you may need to modify the host and port name in the config.yaml