Re: pg_restore - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: pg_restore
Date
Msg-id fg35dl$u96$1@ger.gmane.org
Whole thread Raw
In response to Re: pg_restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_restore  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote on 28.10.2007 23:18:
> Oh, I just twigged that you are using a plain-SQL dump file (that is,
> you didn't specify -Fc or -Ft to pg_dump).  For plain-SQL dumps you
> should not use pg_restore at all; you feed those to psql.

While we are on the topic of pg_dump/pg_restore:

Why is it, that pg_dump can use a compressed output directly but pg_dumpall is
always using a SQL (i.e. "plain text") output?

Thomas

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: pg_restore
Next
From: Tom Lane
Date:
Subject: Re: pg_restore