I worked with many different databases (SQL Server, Oracle, IBM db2) and for all of them if we have a backup it is just enough to execute RESTORE command in order to restore the data.
I am beginner in PostgreSQL.
As I see in documentation and on this question also https://stackoverflow.com/questions/35289888/restore-postgres-database-dump for succesfull restoration of the database we need to:
* DROP database * CREATE database * execute psql dbname < dumpfile
I am really confused (based on the behavior from all other databases ) that we need to drop and recreate database if we want to restore? It's hard for me to believe that Postgres really is implemented in that way.