pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to setup tablespace and table partitioning in a template?
2+ messages / 2 participants
[nested] [flat]
* How to setup tablespace and table partitioning in a template?
@ 2008-07-12 13:37 Michelle Konzack <linux4michelle@tamay-dogan.net>
2008-07-14 18:10 ` Re: How to setup tablespace and table partitioning in a template? Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Michelle Konzack @ 2008-07-12 13:37 UTC (permalink / raw)
To: pgsql-admin
************************************************************************
* 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to setup tablespace and table partitioning in a template?
2008-07-12 13:37 How to setup tablespace and table partitioning in a template? Michelle Konzack <linux4michelle@tamay-dogan.net>
@ 2008-07-14 18:10 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2008-07-14 18:10 UTC (permalink / raw)
To: Michelle Konzack <linux4michelle@tamay-dogan.net>; +Cc: pgsql-admin
On Sat, Jul 12, 2008 at 7:37 AM, Michelle Konzack
<linux4michelle@tamay-dogan.net> 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-07-14 18:10 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-07-12 13:37 How to setup tablespace and table partitioning in a template? Michelle Konzack <linux4michelle@tamay-dogan.net>
2008-07-14 18:10 ` Scott Marlowe <scott.marlowe@gmail.com>
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