Search Postgresql Archives

Re: Problem with pg_dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.wood@xxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux