Re: pg_restore -d doesn't display output

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(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:34:53
Message-ID: 200310061634.h96GYr103633@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane wrote:
> 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.

I don't understand why sending something to a backend should effect the
script output.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sean Chittenden 2003-10-06 17:01:36 Re: count(*) slow on large tables
Previous Message Andrew Dunstan 2003-10-06 16:27:06 Re: more on initdb

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2003-10-06 17:40:04 Re: brazilian portuguese translations
Previous Message Tom Lane 2003-10-06 16:12:01 Re: pg_restore -d doesn't display output