How to transfer a database dump from Ubuntu to Windows?

Question

PostgreSQL

There is Ubuntu with postgresql database. It is necessary to transfer the same base to Windows. On Ubuntu I did a dump like this:

sudo su - postgres
pg_dump postgres > postgres_db.sql

On Windows I import like this:

"C:\Program Files\PostgreSQL\10\bin\psql.exe" test < "E:\\Shared\\backup.sql"

You must then enter a password. I enter the password and get an error

psql: ВАЖНО:  пользователь "User" не прошёл проверку подлинности (по паролю)

spoiler

I don't understand why. First, it is not clear which user's password is requested? There were no passwords on Windows. So the password is from ubuntu, but there is an administrator password, and there is a postgresql user password. In any case, neither one nor the other password is suitable. How can I import a dump into a database on Windows? Help, just a cry from the heart.

Answer 1

https://stackoverflow.com/questions/9736085/run-a-...

Answer 2

It has nothing to do with any source database passwords.
The question is solely about setting up your base in this exotic windows environment.
The one you told psql to connect to. Since you didn't specify the appropriate -U switch, and most likely didn't define an environment variable, psql tries to use the same username as the open console username.
The error said in plain text that password authentication was used, as a result, there was no user with such a password in the database. Figure out how to log in to the database in your system, it has nothing to do with dumps.