Re: pg_dump -Fc does not dump indexes

Hi Tom,
thanks for answering so quickly!

The error occurs for me using pg_dump and pg_restore on postgres 8.0.3
running on RedHat ES4. But also occurs if I take the dump from the Linux
box and run restore on a winxp box with postgres 8.0.2.

I would definetely be willing to create a self contained test case but I
am not sure what that would be. I can create a dump file from a test
database, but that would be after using pg_dump so you could not check
that. Do you want me to create a database, shut it down and zip up the
database files? Which files would those be?

Is there a way for me to find out if the dump file created with -Fc does
contain information on the indexes?

Thanks,
Alberto

>> I have tried to backup my postgres database with
>> pg_dump -Fc $db > ~/backups/$db.backup.c
>> and restore it with:
>> createdb -U postgres -D aestel_admin -T template0 restoreTMP
>> pg_restore -d restoreTMP -U postgres $db.backup.c

>> I do not get any error messages but none of my indexes are created.

>Works for me ... can you create a self-contained test case? What PG
>version are you using, anyway (and are you sure the pg_dump and
>pg_restore programs are of the same version)?
> regards, tom lane