Is there a "pg_restore --quiet" option like "psql --quiet"?

user_875915 0
Viewed 19930

psql has a -q / --quiet option (environment variable QUIET). pg_restore does not have a quiet option. Is there any way to make pg_restore not verbosely show the SQL commands that it's executing?

# e.g., here's the verbose output that I don't want to see:
$ pg_restore --cluster 8.4/mycluster mycluster.dump
---- PostgreSQL database dump
--
SET statement_timeout = 0;SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;SET check_function_bodies = false;
...
--
-- Name: data_src; Type: TABLE; Schema: public; Owner: postgres; Tablespace:--
CREATE TABLE data_src (
...
postgresql-9.1 pg-restore psql postgresql
2 Answers

You can redirect stdout to a file:

pg_restore --cluster 8.4/mycluster mycluster.dump > pg_restore.log

Or provide the -d option, but what you want is either -f or -d

pg_restore -f pg_restore.sql --cluster 8.4/mycluster mycluster.dump
pg_restore -d yourdatabase --cluster 8.4/mycluster mycluster.dump
user_20854690
Related