From: Vishal Kashyap @ [Sai Hertz And Control Systems] <vishalonlist@gmail.com>
To: Düster Horst <horst.duester@bd.so.ch>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: pg_restore error
Date: Fri, 29 Oct 2004 16:02:51 +0530
Message-ID: <77b69d21041029033267707641@mail.gmail.com> (raw)
In-Reply-To: <5B025B1F39D6D4119F5700508BEEEC66F94BF4@SRSOFAIOI4546>
References: <5B025B1F39D6D4119F5700508BEEEC66F94BF4@SRSOFAIOI4546>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vishalonlist@gmail.com, horst.duester@bd.so.ch
Subject: Re: pg_restore error
In-Reply-To: <77b69d21041029033267707641@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox