Re: pg_restore - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: pg_restore
Date
Msg-id 20121208164035.142820@gmx.com
Whole thread Raw
In response to pg_restore  (Branka Stancic <brankastancic@hotmail.com>)
List pgsql-bugs
Branka Stancic wrote:

> I using command pg_restore

> get an error: pg_restore: [archiver] input file appears to be a
> text format dump. Please use psql

pg_restore is not used for restoring text files; psql is. If you
want to use pg_restore you should use -Fc when you run pg_dump. At
this point, you need to run the script file in through psql. If it
contains steps you don't want to execute, you will need to copy and
edit the file to leave just the portions you want to run.

-Kevin

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Installing PG 7.3.4 on Linux 6
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #7733: support Retina display in pgAdmin