Skip site navigation (1) Skip section navigation (2)

Re: pg_restore error

From: "Vishal Kashyap (at) [Sai Hertz And Control Systems]" <vishalonlist(at)gmail(dot)com>
To: Düster Horst <horst(dot)duester(at)bd(dot)so(dot)ch>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_restore error
Date: 2004-10-29 10:32:51
Message-ID: 77b69d21041029033267707641@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi 

> 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.


pg_restore does not priortize till  now idealy it must be like
restoring the functions >> tables >> views >> seqences so on...

This is in the todo

http://developer.postgresql.org/todo.php

but for mean while you would have to use pg_restore to restore the
tables one by one and then let other thing go on.

moreover if your database is not to large its best to make a text file
of the dump and run it through psql


-- 
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com

In response to

pgsql-admin by date

Next:From: Düster HorstDate: 2004-10-29 11:12:07
Subject: pg_restore error
Previous:From: Ivan DimitrovDate: 2004-10-29 10:04:35
Subject: pg_autovacuum is not working

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group