Re: Problem restoring with pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Wilson <petew(at)yellowhawk(dot)co(dot)uk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problem restoring with pg_dump
Date: 2006-12-01 19:32:45
Message-ID: 1693.1165001565@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Peter Wilson <petew(at)yellowhawk(dot)co(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2006-12-01 22:43:12 Re: PostgreSQL and Performance of Functions
Previous Message Kim 2006-12-01 19:29:26 Re: Create table/view/index hanging following server crash