Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: douggorleyDate: 2003-03-19 18:15:54
Subject: Re: Regardin storing images
Previous:From: Patrick HatcherDate: 2003-03-19 18:00:23
Subject: Re: Problems with copy

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group