Thread: pg_restore vs. indexes

pg_restore vs. indexes

From
daq
Date:
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