Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5E6286506C6 for ; Mon, 14 Jul 2008 15:12:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 59011-01-6 for ; Mon, 14 Jul 2008 15:12:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.176]) by postgresql.org (Postfix) with ESMTP id A8DB365070A for ; Mon, 14 Jul 2008 15:10:48 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id n4so2790743wag.5 for ; Mon, 14 Jul 2008 11:10:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=ggGxntE1CasvaybnbqFIHNwOdSJsKxe2eVS4gAjpV9E=; b=h7filP2GOOd4YW8Bc8zUtd9JQ9H/b4NIUTN9+pEXb3khzqnhCYoFfIXF7gPwGL5ZAw v6cUQd9jvOloTwtByxkw50X+OE9iezSOvZ+2MoxeP+HH8CxfRf6sN7ZmREC+ss7CoNIe N6doSKYx4PTpDw5bVlRHgzkYTPosdRaiwYKhg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=Zo5DHX6E/Q3IUirMNIuPQqj7iQK7YIdZ74nayWZnYS4frXeHveGDcONTesz1lAdHfc DlH37r7g2vfoOI0lE7D5vgo7Zsi/6wsAMJDERichYIzN2eu4z9fvUOwLpwFc5fDH2iDV qz/OzXz0obMI32o7lAl4LNZVUV3+Fe2qew1DA= Received: by 10.114.144.1 with SMTP id r1mr17863705wad.97.1216059047264; Mon, 14 Jul 2008 11:10:47 -0700 (PDT) Received: by 10.114.130.17 with HTTP; Mon, 14 Jul 2008 11:10:46 -0700 (PDT) Message-ID: Date: Mon, 14 Jul 2008 12:10:46 -0600 From: "Scott Marlowe" To: "Michelle Konzack" Subject: Re: How to setup tablespace and table partitioning in a template? Cc: "pgSQL - Admin" In-Reply-To: <20080712133752.GN24484@freenet.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20080712133752.GN24484@freenet.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/125 X-Sequence-Number: 29735 On Sat, Jul 12, 2008 at 7:37 AM, Michelle Konzack wrote: > ************************************************************************ > * Do not Cc: me, because I READ THIS LIST, if I write here * > * Keine Cc: am mich, ich LESE DIESE LISTE wenn ich hier schreibe * > ************************************************************************ > > Hello, > > Our PostgreSQL server is using two SCSI Raid-1 controllers (each two > channels) and I have 5 sets per channel (each two HDD in Raid-1 with one > HotFix). In summary we have currently 15 Sets. > > Sometimes we have the need to duplicate servers and I tried to use the > database scheme dump to install a new server... > > This dos not work. ALL databases and tables are created on a singel > Raid-1 (the first one) and tablespace is ignored. > > Can anyone post an example how to do this, so I can edit my pgSQL dump > sheme to correct this issue? Well, I would use pg_dump -s to get the schema, then edit it by hand to have the tablespace options I needed, then save it. In the future as you change your hardware setup you can edit the file again to match that setup. Then you can save a version of that file for each server, since the hardware may not be the same. I tend to start with SQL and move it to the server, not start with the server then dump the sql.