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