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.