From the command prompt - I've successfully used:
"C:\Program Files\PostgreSQL\9.1\bin\pg_restore" -h {serverIP} -U {UserID} -C -d {targetDB} M:\LongitudinalDB\backups\2013.10.02\uw.sql
But, if you use "C:\Program Files\PostgreSQL\9.1\bin\pg_restore" --help
... at a command prompt, you'll get some more help.
Of course, you need to make sure your installation is in this location...
Ken Benson
On 10/18/2013 7:22 AM, Erin Jonaitis wrote:
Thanks, all. I did also try this from the Windows command prompt -- it gave
me the standard error it gives when it has no idea what you're talking
about: "'psql' is not recognized as an internal or external command,
operable program or batch file." Any Windows PostgreSQL users present?
Erin
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of David Johnston
Sent: Friday, October 18, 2013 9:19 AM
To: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Restoring from SQL dump
Erin Jonaitis wrote
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.
#3 - you are now in psql
#4 - you are acting as if you are sitting at your OS shell prompt here
Either learn the psql to run an external file or get back to your OS shell
prompt and run the psql command from there.
Not sure why you did't get more errors.
Yes, backslashes inside psql denote the intent to use a special command
which "Long..." is not.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Restoring-from-SQL-dump-tp5775028p57
75031.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice