Re: pg_dump ,pg_restore problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Ruff <mruff(at)simeon(dot)ch>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_dump ,pg_restore problem
Date: 2003-03-19 18:03:11
Message-ID: 7956.1048096991@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Martin Ruff <mruff(at)simeon(dot)ch> writes:
> I dump a table and then try to restore and get the error message
> [archiever] input file does not appear to be a valid archive

The default output from pg_dump is a script that you feed to psql.
pg_restore is only used for -Fc or -Ft dumps.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message douggorley 2003-03-19 18:15:54 Re: Regardin storing images
Previous Message Patrick Hatcher 2003-03-19 18:00:23 Re: Problems with copy