Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 21BDE650329 for ; Sun, 13 Jul 2008 12:59:27 -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 03286-09 for ; Sun, 13 Jul 2008 12:59:22 -0300 (ADT) X-Greylist: delayed 00:07:12.755203 by SQLgrey-1.7.6 Received: from server4.pinguin-hosting.de (server4.pinguin-hosting.de [88.198.11.108]) by postgresql.org (Postfix) with ESMTP id DB3BD64FED7 for ; Sun, 13 Jul 2008 12:59:18 -0300 (ADT) Received: from tp570.private.tamay-dogan.net (lec67-1-81-56-104-13.fbx.proxad.net [81.56.104.13]) (Authenticated sender: linux4michelle@tamay-dogan.net) by server4.pinguin-hosting.de (Postfix) with ESMTP id E1942578AD6 for ; Sun, 13 Jul 2008 17:52:08 +0200 (CEST) Received: by tp570.private.tamay-dogan.net (sSMTP sendmail emulation); Sun, 13 Jul 2008 17:51:40 +0200 Received: by tp570.private.tamay-dogan.net (TDSSMTP outspool); Sat, 12 Jul 2008 15:37:53 +0200 Date: Sat, 12 Jul 2008 15:37:52 +0200 From: Michelle Konzack To: pgSQL - Admin Subject: How to setup tablespace and table partitioning in a template? Message-ID: <20080712133752.GN24484@freenet.de> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="nb8zVy0QMK3AA1xu" Content-Disposition: inline X-Message-Flag: Improper configuration of Outlook is a breeding ground for viruses. Please take care your Client is configured correctly. Greetings Michelle. X-Disclaimer-DE: Eine weitere Verwendung oder die Veroeffentlichung dieser Mail oder dieser Mailadresse ist nur mit der Einwilligung des Autors gestattet. Organization: Tamay Dogan Network X-Operating-System: Linux tp570 2.4.27-2-686 X-Uptime: 15:19:23 up 18:12, 7 users, load average: 0.08, 0.13, 0.16 X-Homepage: http://www.debian.tamay-dogan.net/ User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.541 tagged_above=0 required=5 tests=AWL=1.131, SUBJECT_FUZZY_TION=0.41 X-Spam-Level: * X-Archive-Number: 200807/118 X-Sequence-Number: 29728 --nb8zVy0QMK3AA1xu Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable ************************************************************************ * 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? Note: It is not very funny to setup each time 15 Raid-1 sets by hand since the PostgreSQL has now reached 1400 GByte and we will use the second channel of the second controller to attach again 15 new drives which then support up to 2.9 TByte. The drives have all 146 GByte. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant --=20 Linux-User #280138 with the Linux Counter, http://counter.li.org/ ##################### Debian GNU/Linux Consultant ##################### Michelle Konzack Apt. 917 ICQ #328449886 +49/177/9351947 50, rue de Soultz MSN LinuxMichi +33/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com) --nb8zVy0QMK3AA1xu Content-Type: application/pgp-signature; name="signature.pgp" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFIeLOwC0FPBMSS+BIRAl3NAJ9rejpyaDXZNKqlbpITzKK0kN9lqQCeOo01 h7l9fIyvaJ/6P/fLm3lSyJg= =7AN6 -----END PGP SIGNATURE----- --nb8zVy0QMK3AA1xu--