Re: pg_restore

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Bob Pawley <rjpawley(at)shaw(dot)ca>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: pg_restore
Date: 2007-10-28 22:15:39
Message-ID: 200710281515.39475.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday 28 October 2007 3:01 pm, Bob Pawley wrote:
> 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
What does your dump command look like? My guess is your are doing a plain text
dump and pg_restore only works with the custom formats. If you want to use
the plain text version than you need to use psql. This maybe how you got to
the point of having both pg_restore and psql on the same line.
--
Adrian Klaver
aklaver(at)comcast(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-10-28 22:18:57 Re: pg_restore
Previous Message Bob Pawley 2007-10-28 22:01:58 Re: pg_restore