How to restore a PostgreSQL database?

Question

PostgreSQL

I downloaded the database from this resource for training purposes: https://postgrespro.ru/docs/postgrespro/13/demodb-...
I'm trying to restore the database through pgAdmin 4. It gives an error. I do not know what to do. The database is necessary for the assimilation of the material.

Error:


Thank you for your attention!

Answer 1

The pg_restore utility is designed to restore a Postgres Pro database from an archive created by the pg_dump command in any of the non-text formats

https://postgrespro.ru/docs/postgrespro/10/app-pgr...
You have a dump in SQL (text format).
There is no pgAdmin4 at hand (may Allah punish its creator), but somewhere there should be a button like "run SQL script", or "open SQL console" - you need to restore it from there.
Well, or run the console and in it the command that pgAdmin writes with replacing pg_restore.exe with psql.exe, and put <. About:

C:\Program Files\...\psql.exe --host ... --dbname "demo" < "C:\\Users\\...\\....SQL"

Answer 2

It would not be bad to deal with the encoding in order to understand what is wrong with him.
Postgres user doesn't have a password?
Try to create an empty demo database first, and then restore the data from the downloaded dump into it.