Re: pg_restore

Hi Adrian

With pg_restore psql -h localhost -d PDW -U postgres aurel.sql the error
message is -

pg_restore: could not open input file: No such file or directory exists.

I get this message with aurel.sql - or aurel - or the path to aurel
(......8,2\bin) or when aurel is not even mentioned.

This is becoming quite frustrating.

Bob
----- Original Message -----
From: "Adrian Klaver" <aklaver(at)comcast(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Sent: Sunday, October 28, 2007 11:45 AM
Subject: Re: [GENERAL] pg_restore

> On Sunday 28 October 2007 11:32 am, Bob Pawley wrote:
>> Please help.
>>
>> I am attempting to restore a database into PostgreSQL version 8.2 running
>> on Win XP Professional.
>>
>> From the 'bin' folder, I am using the command line-
>> pg_restore psql -h localhost -d PDW -U postgres -f aurel.sql
>
> Try pg_restore psql -h localhost -d PDW -U postgres aurel.sql
> No -f switch
>
>>
>> I get an error -
>>
>> pg_restore: cannot specify both -d and -f output.
>>
>> If the error message is correct how does pg_restore know what to put
>> where?
>
> The -d switch tells pg_restore to the named database. The -f switch tells
> it
> to restore to named file. It won't do both.
>
>>
>> I used the same command to successfully install the same pg_dump file
>> into
>> PostgreSQL 8.1 running on the same computer.
>
> Maybe 8.1 ignored the error.
>
>>
>> Any thoughts would be much appreciated.
>>
>
>
> --
> Adrian Klaver
> aklaver(at)comcast(dot)net