Re: Restoring from SQL dump

Try:
pg_restore M:\LongitudinalDB\backups\2013.10.02\uw.sql

On 10/18/2013 6:57 AM, Erin Jonaitis wrote:
>
> 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
>