Re: pg_dump ,pg_restore problem - Mailing list pgsql-novice

From Tom Lane
Subject Re: pg_dump ,pg_restore problem
Date
Msg-id 7956.1048096991@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump ,pg_restore problem  (Martin Ruff <mruff@simeon.ch>)
List pgsql-novice
Martin Ruff <mruff@simeon.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

pgsql-novice by date:

Previous
From: phil campaigne
Date:
Subject: permission denied
Next
From: "Patrick Hatcher"
Date:
Subject: Re: Problems with copy