From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] pg_restore -d doesn't display output |
Date: | 2003-10-08 04:44:45 |
Message-ID: | 200310080444.h984ijV08758@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Bruce Momjian wrote:
> 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.
I have patched pg_restore to output the script contents if you restore
with -v:
pg_restore -v -d test /tmp/x
Patch attached. I will save this for 7.5.
--
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
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 1.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2003-10-08 06:35:53 | Re: BigInt woes |
Previous Message | Tom Lane | 2003-10-08 03:21:21 | Re: Triggers on SELECT? |
From | Date | Subject | |
---|---|---|---|
Next Message | Manfred Koizar | 2003-10-08 09:31:30 | Re: [HACKERS] Cannot dump/restore text value \N |
Previous Message | Bruce Momjian | 2003-10-08 03:53:09 | Re: Bug in pg_restore memory handling |