pg_restore vs. indexes

From: daq <daq(at)ugyvitelszolgaltato(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_restore vs. indexes
Date: 2002-07-24 11:50:20
Message-ID: 5113253322.20020724135020@ugyvitelszolgaltato.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
toc.txt text/plain 6.5 KB

Browse pgsql-sql by date

  From Date Subject
Next Message ROUWEZ Stephane 2002-07-24 11:52:40 Problem with my query whithout double-quotes
Previous Message Achilleus Mantzios 2002-07-24 10:56:51 Re: pg_dump and sequences