Error during importing SQL when deploying Teledrive to Heroku

[tan-yong-sheng]

Describe the bug Error during importing sql when deploying Teledrive to Heroku, for example, "must be owner of extension pg_stat_statements", " must be owner of extension uuid-ossp", and "must be member of role 'postgres'"

For more info, see the screenshots attached below.

To Reproduce Steps to reproduce the behavior:

1. Follow the steps of heroku deployment shown in https://teledriveapp.com/docs/Deployment/heroku/
2. Type heroku config:set USE_PSQL_HEROKU=1 into cmd
3. Type heroku config:set DATABASE_URL=YOUR_DB_CONNECTION_URI into cmd
4. Type heroku pg:psql --app YOUR_APP_NAME -f ./server/src/model/migrations/dump.sql into cmd
5. Type heroku pg:psql --app YOUR_APP_NAME -f ./server/src/model/migrations/dump.20220406.sql into cmd

Note:

1. I am using Windows 11 to deploy this app to heroku. I have installed the heroku-cli and postgresql to my windows machine.
2. YOUR_DB_CONNECTION_URI= postgres://xidnnqiamazonaws.com:/d5vn1rqg25 （I hide it for privacy purpose）
3. YOUR_APP_NAME = example-teledrive

Expected behavior It works well when importing sql.

Screenshots

Desktop (please complete the following information):

• OS: Windows 11
• Browser Chrome

Additional context

1. Problem that I have solved: https://github.com/heroku/legacy-cli/issues/334 How I solve: set PATH=%PATH%;C:\Program Files\PostgreSQL\9.2\bin\

2. Another problem that I haven't yet solved: https://github.com/EricSmekens/jsep/issues/218

[mgilangjanuar]

It's okay, you can continue the installation process. I'll fix the SQL files.

[mgilangjanuar]

try pull the latest changes