Re: Problem with pg_dump

Well yes - thats what I mean, the definition for the index. It's not
dumping the index defs. It also looks like it's not dumping roles fully
either. I was missing grants from the dump too.

Alex

On 11/9/06, Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz> wrote:
>
> A. Kretschmer wrote:
> > am Thu, dem 09.11.2006, um 13:04:31 -0500 mailte Alex Turner folgendes:
> >
> >> I seem to be having a problem with pg_dump in 8.1.2, it's not dumping
> indexes
> >> at all. Is this a known problem, should I just do an upgrade?
> >>
> >
> > I can't see a necessity to dump a index. But, i hope, and i'm sure,
> > pg_dump dumps the definition for a index...
> >
> >
> The dump includes the sql statements ro build the indices as part of the
> restore process, the contents of the indices are not dumped. At least in
> my experience.
>
> Brent Wood
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>