From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Adrian Klaver <aklaver(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_restore |
Date: | 2007-10-28 22:01:58 |
Message-ID: | 000c01c819ae$2a89ffb0$6401a8c0@owner |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Adrian Klaver" <aklaver(at)comcast(dot)net>; <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, October 28, 2007 2:28 PM
Subject: Re: [GENERAL] pg_restore
> Bob Pawley <rjpawley(at)shaw(dot)ca> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2007-10-28 22:15:39 | Re: pg_restore |
Previous Message | Adrian Klaver | 2007-10-28 21:38:08 | Re: pg_restore |