Re: backup and restore questions - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: backup and restore questions
Date
Msg-id 20040223192610.GA17164@svana.org
Whole thread Raw
In response to Re: backup and restore questions  ("Sally Sally" <dedeb17@hotmail.com>)
List pgsql-general
On Mon, Feb 23, 2004 at 04:28:48PM +0000, Sally Sally wrote:
> I was trying to restore a zipped plain text dump created like this:
>
> pg_dump --table=class --data-only school | gzip > school_class_dump.gz

<snip>
>
> Does pg_restore really recognize plain text (version 7.4)?

Nope, never has. For plain text dumps, just use psql.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
>    http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow

Attachment

pgsql-general by date:

Previous
From: "Sally Sally"
Date:
Subject: Re: backup and restore questions
Next
From: "Ed L."
Date:
Subject: Re: Found this in the server log on MAC OSX