| From: | Düster Horst <Horst(dot)Duester(at)bd(dot)so(dot)ch> |
|---|---|
| To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | pg_restore error |
| Date: | 2004-10-29 11:12:07 |
| Message-ID: | 5B025B1F39D6D4119F5700508BEEEC66F94BF4@SRSOFAIOI4546 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hallo
I try to restore a large DB with BLOBS. I created the dump file with:
pg_dump -Fc -b <dbname> > dump.file
During the restore process startet with the following command:
pg_restore -d <dbname> dump.file
the process breakes with the error message that a table couldn't be found.
So I started the pg_restore in verbose mode. This mode offers the problem.
pg_restore tries to create a view but a referenced table does not exists. I
thought, that pg_restore will organize the restore-prozess in an optimal
order. This seems not work correct!!?? I would be grateful to hear any
hints.
My system:
Postgresql 7.4.5
SuSe 9.1 Linux
With best regards
Horst Düster
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Düster Horst | 2004-10-29 11:38:37 | Re: pg_restore error |
| Previous Message | Vishal Kashyap @ [Sai Hertz And Control Systems] | 2004-10-29 10:32:51 | Re: pg_restore error |