The latest in the saga -
By using - pg_restore -h localhost -d PDW -U postgres aurel.sql
I get the message - pg_restore: input file does not appear to be a valid
archive.
I get this message when I used the aurel.sql file which I previously loaded
successfully in 8.1 and also when I use an aurel.sql file which I just
successfully dumped a few minutes ago from the 8.1 on my other computer.
Could pg_restore in my 8.2 be corrupted??
Bob
----- Original Message -----
From: "Tom Lane" <tgl@xxxxxxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Adrian Klaver" <aklaver@xxxxxxxxxxx>; <pgsql-general@xxxxxxxxxxxxxx>
Sent: Sunday, October 28, 2007 2:28 PM
Subject: Re: pg_restore
Bob Pawley <rjpawley@xxxxxxx> writes:
This is becoming quite frustrating.
The errant "psql" is your problem ... although pg_restore is being
quite unhelpful by not mentioning the filename that it's trying to open.
regards, tom lane
---------------------------(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
