This will be probably extreme novice question but I want to restore a .backup dump file. I have tried the following command:
pg_restore -i -h localhost -p 5432 -U postgres -d old_db -v C:/blabla/bla.backup
First error I have encountered because the dump file is in text format so I should restore it using psql.
Then I have tried this command:
psql dbname < C:/blabla/bla.backup
But didn't accept the password of my windows user password