Re: pg_restore -d doesn't display output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_restore -d doesn't display output
Date: 2003-10-06 16:12:01
Message-ID: 27758.1065456721@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Does anyone know why 'pg_restore -d' doesn't display the commands being
> executed, like you see when you don't use '-d':

> pg_restore < /tmp/test.db
> pg_restore -d test < /tmp/test.db

The first sends a script to stdout (effectively equivalent to pg_dump
plain style). The second sends the commands to a backend.

I would have expected there to be a --verbose option that would also echo
the commands to stderr, but it doesn't look like there's any support for
that in the code.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2003-10-06 16:12:45 Re: more on initdb
Previous Message Tom Lane 2003-10-06 16:05:29 Re: more on initdb

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-10-06 16:34:53 Re: pg_restore -d doesn't display output
Previous Message Bruce Momjian 2003-10-06 15:46:33 Re: fix log_min_duration_statement logic error