Hello!
I am trying to restore data from an SQL dump. I am using Windows 7, PostgreSQL version 9.3, pgAdmin III 1.18.0.
Here is what I did.
1) I used the pgAdmin III interface to create a new database.
2) I selected this db in the console and selected Plugins > PSQL console.
3) Now I have a psql window open with the following prompt:
dbname=#
4) I tried typing the following:
psql –f M:\LongitudinalDB\backups\2013.10.02\uw.sql
and got the following error:
Invalid command \LongitudinalDB. Try \? For help.
5) OK, so maybe the backslashes are the problem. I then tried
psql –f M:/LongitudinalDB/backups/2013.10.02/uw.sql
and got no error.
6) However, none of the data or tables appeared in the db – it looks just as it did as a fresh db.
7) I tried a few other things in the psql window, deliberately typing nonsense. No error messages then, either, just a fresh prompt.
Advice would be much appreciated.
Thanks,
Erin