From: Michelle Konzack <linux4michelle@tamay-dogan.net>
To: pgSQL - Admin <pgsql-admin@postgresql.org>
Subject: How to setup tablespace and table partitioning in a template?
Date: Sat, 12 Jul 2008 15:37:52 +0200
Message-ID: <20080712133752.GN24484@freenet.de> (raw)
************************************************************************
* 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
--
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)
Attachments:
signature.pgp (application/pgp-signature, 188B) download
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: linux4michelle@tamay-dogan.net
Subject: Re: How to setup tablespace and table partitioning in a template?
In-Reply-To: <20080712133752.GN24484@freenet.de>
* 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