470,614 Members | 1,458 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

pg_restore fails

Colleagues,

On postgresql-7.4, pg_restore fails to restore a database because it
tries to create some views referencing other objects which is has not
created yet.

Is there any way to fix or workaround this except editing the dump
with a text editor (very frustrating with dozens of objects in several
schemas being out of order)?

Thanks a lot for any ideas.

--
Victor Sudakov, VAS4-RIPE, VAS47-RIPN
2:5005/49@fidonet http://vas.tomsk.ru/
Sep 16 '05 #1
0 1305

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Joshua D. Drake | last post: by
14 posts views Thread by Ron Johnson | last post: by
7 posts views Thread by Howard Lowndes | last post: by
11 posts views Thread by Ben Marklein | last post: by
6 posts views Thread by Mike Charnoky | last post: by
7 posts views Thread by Tim Penhey | last post: by
1 post views Thread by ruben | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.