Re: pg_restore

[Bob Pawley <rjpawley@xxxxxxx>]

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@xxxxxxxxxxx>
To: <pgsql-general@xxxxxxxxxxxxxx>
Cc: "Bob Pawley" <rjpawley@xxxxxxx>
Sent: Sunday, October 28, 2007 11:45 AM
Subject: Re:  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@xxxxxxxxxxx 


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match