Postgresql upload error on heroku?

Question

PostgreSQL

I want to upload my postgresql database to Heroku, but I ran into one moment, which I can’t find the answer anywhere (I’m asking a question outside of Google for the first time).
When trying to load the database through the command line, a password request is displayed, but not for the database user, but for the windows user.
I found a command on Heroku that seems to be able to use a different user/password binding:
PGUSER=postgres PGPASSWORD=password heroku pg:push HEROKU_POSTGRESQL_MAGENTA mylocaldb --app
sushi to do this ... but by default it still uses the windows user (but no password is suitable)


DBMS version 11 and after unsuccessful attempts tried to install 13, but nothing changed

Answer 1

Execute (with real user and password, of course)

heroku config:set PGUSER=postgres PGPASSWORD=password

And then your command to download the dump