The backup being a text file is completely normal.
I personally am more of a command line guy, so you'll excuse the reversion to the command line, I hope. I don't have as much experience with PGAdmin.
Start --> Programs --> PostgreSQL --> Command Prompt.
at the command prompt type:
- Code: Select all
pg_restore -U postgres <filename>
where <filename> is the full name and location of your backup file (C:\...etc).
That should be all you need to do.
If that doesn't work let me know what error you get and we'll work from there.