Re: Restoring a pg_dumped file...

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Timothy Grant <tjg(at)craigelachie(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restoring a pg_dumped file...
Date: 2002-12-12 22:40:57
Message-ID: 1039732857.11315.1.camel@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2002-12-12 at 21:57, Timothy Grant wrote:
> I'm sure I'm doing something completely stupid, and it's really not too
> important as I don't have any data in this database yet, but I can't get
> a file dumped with pg_dump under 7.2.3 to restore with pg_restore in
> 7.3.
>
> (tjg(at)reepicheep%) pg_restore
> tjg.db_dump ~
> pg_restore: [archiver] input file does not appear to be a valid archive
>
> So, what silly thing am I not doing right?

I wonder how you created it?

If you said: "pg_dump >dumpfile", you can't use pg_restore. You should
use "psql <dumpfile"

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Be of good courage, and he shall strengthen your
heart, all ye that hope in the LORD."
Psalms 31:24

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Timothy Grant 2002-12-12 22:44:13 Re: Restoring a pg_dumped file...
Previous Message Jean-Luc Lachance 2002-12-12 22:39:44 Re: [PERFORM] CLUSTER command