pg_restore vs. indexes - Mailing list pgsql-sql

From daq
Subject pg_restore vs. indexes
Date
Msg-id 5113253322.20020724135020@ugyvitelszolgaltato.hu
Whole thread Raw
List pgsql-sql
Hi all!

I try dump and restore my database, but i got some trouble with
indexes.

I dumped my database with pg_dump:
pg_dump --format c --file=/home/postgres/bydump byenet

After this i try to restore the db:
pg_restore -c -d byprb /home/postgres/bydump
pg_restore: [archiver (db)] could not execute query: ERROR:  index
"fhelyhist_fhszam_ind" does not exist

If i drop the index before the pg_dump, then the same hapens with
another index.

What i do wrong?

DAQ

Ps.: The TOC of the dump is atached.
Attachment

pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: pg_dump and sequences
Next
From: Elielson Fontanezi
Date:
Subject: RES: Queries not using Index