X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 33F663A3E7A for ; Fri, 29 Oct 2004 11:32:57 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55186-10 for ; Fri, 29 Oct 2004 10:32:52 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.205]) by svr1.postgresql.org (Postfix) with ESMTP id A4DAC3A3B51 for ; Fri, 29 Oct 2004 11:32:51 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 64so615000wri for ; Fri, 29 Oct 2004 03:32:51 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=G+BQ1u7UsYTakyfOt6NtpBAFGMsI9KgKdoV37hqjv0mPg2FsW2GlG1iBcCkgqLyiHbETD8L6PkiGLNfJCW3R+cWwJ5Cw76l65ggkGhJ7E75rGVZWmpwVv4Z6r1UII7ByLHXVr5ga1wuLjlZ1uB0iIkK9DhN6VMA8htYhlUTy1cM= Received: by 10.54.35.9 with SMTP id i9mr158027wri; Fri, 29 Oct 2004 03:32:51 -0700 (PDT) Received: by 10.54.26.13 with HTTP; Fri, 29 Oct 2004 03:32:51 -0700 (PDT) Message-ID: <77b69d21041029033267707641@mail.gmail.com> Date: Fri, 29 Oct 2004 16:02:51 +0530 From: "Vishal Kashyap @ [Sai Hertz And Control Systems]" Reply-To: "Vishal Kashyap @ [Sai Hertz And Control Systems]" To: =?ISO-8859-1?Q?D=FCster_Horst?= Subject: Re: pg_restore error Cc: "pgsql-admin@postgresql.org" In-Reply-To: <5B025B1F39D6D4119F5700508BEEEC66F94BF4@SRSOFAIOI4546> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <5B025B1F39D6D4119F5700508BEEEC66F94BF4@SRSOFAIOI4546> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/371 X-Sequence-Number: 15364 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