Re: Problem restoring with pg_dump - Mailing list pgsql-admin

From Tom Lane
Subject Re: Problem restoring with pg_dump
Date
Msg-id 1693.1165001565@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem restoring with pg_dump  (Peter Wilson <petew@yellowhawk.co.uk>)
Responses Re: Problem restoring with pg_dump
Re: Problem restoring with pg_dump
List pgsql-admin
Peter Wilson <petew@yellowhawk.co.uk> writes:
> Tom Lane wrote:
>> Could you show us the unmodified output from pg_restore -l, as well as
>> the edits you made to produce the -L script?

> Raw output from pg_restore -l is as follows:

Hm, this shows only data entries.  Was the original pg_dump made with -a,
or did you use -a in the pg_restore -l command?  If the latter, could we
see the full -l output?  I didn't have any luck trying to reproduce this
behavior, so I'm supposing it depends on something you haven't shown us...

            regards, tom lane

pgsql-admin by date:

Previous
From: Kim
Date:
Subject: Re: Create table/view/index hanging following server crash
Next
From: "Simon Riggs"
Date:
Subject: Re: PostgreSQL and Performance of Functions