Restoring from SQL dump

From: Erin Jonaitis <jonaitis(at)wisc(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Restoring from SQL dump
Date: 2013-10-18 13:57:29
Message-ID: 00ab01cecc09$fc2e0750$f48a15f0$@wisc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Payal Singh 2013-10-18 14:12:21 Re: Restoring from SQL dump
Previous Message David Johnston 2013-10-17 20:45:57 Re: error: there is no parameter $1