| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Sally Sally <dedeb17(at)hotmail(dot)com> |
| Cc: | aspire420(at)hotpop(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: backup and restore questions |
| Date: | 2004-02-23 19:26:11 |
| Message-ID: | 20040223192610.GA17164@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg | 2004-02-23 23:29:02 | GRANTing privileges to a plpgsql function doesn't give required result (pg 7.3.4) |
| Previous Message | Sally Sally | 2004-02-23 16:28:48 | Re: backup and restore questions |