Re: Restoring from SQL dump

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(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of David Johnston
> Sent: Friday, October 18, 2013 9:19 AM
> To: pgsql-novice(at)postgresql(dot)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(at)postgresql(dot)org) To make
> changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
>
>