Re: [GENERAL] pg_restore

[Bob Pawley]

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" <[EMAIL PROTECTED]>
To: <pgsql-general@postgresql.org>
Cc: "Bob Pawley" <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED] 


---------------------------(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