Re: Restoring from SQL dump - Mailing list pgsql-novice

Hi Ken,

Thanks for the idea. Tried that too, FWIW (using / instead of \), and it also failed silently, no errors. Pretty unfriendly behavior. I’m used to command lines yelling at me when I do something dumb, but this one just doesn’t.

Erin

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