Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to setup tablespace and table partitioning in a template?

How to setup tablespace and table partitioning in a template?

From
Michelle Konzack
Date:
************************************************************************
*       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)
Attachment

Re: How to setup tablespace and table partitioning in a template?

From
"Scott Marlowe"
Date:
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.