Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 618D22E0186 for ; Fri, 22 Feb 2008 15:43:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 74333-02 for ; Fri, 22 Feb 2008 15:42:50 -0400 (AST) X-Greylist: delayed 00:24:46.555373 by SQLgrey-1.7.5 Received: from smaug.vex.net (smaug.vex.net [208.76.104.132]) by postgresql.org (Postfix) with ESMTP id 129B02E00F6 for ; Fri, 22 Feb 2008 15:42:53 -0400 (AST) Received: from dilbert (dilbert.druid.net [207.35.13.14]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smaug.vex.net (Postfix) with ESMTP id 841EB17C97; Fri, 22 Feb 2008 14:18:04 -0500 (EST) Date: Fri, 22 Feb 2008 14:18:03 -0500 From: "D'Arcy J.M. Cain" To: Susan Russo Cc: pgsql-admin@postgresql.org Subject: Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' Message-Id: <20080222141803.5edaa16b.darcy@druid.net> In-Reply-To: <200802221837.m1MIbhZS001801@larrys.harvard.edu> References: <200802221837.m1MIbhZS001801@larrys.harvard.edu> X-Mailer: Sylpheed 2.4.8 (GTK+ 2.12.7; x86_64--netbsd) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/289 X-Sequence-Number: 28363 No need to crosspost. I removed -performance from the Cc. On Fri, 22 Feb 2008 13:37:43 -0500 (EST) Susan Russo wrote: > I'm wondering if anyone has had success doing a simultaneous > load of one Pg dump to two different servers? The load command > is actually run from two different workstations, but reading the > same pgdump-file. Do you have any reason to doubt that this would work? Have you tried it? As long as the targets are different I don't see any problem. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.