From: Scott Marlowe <scott.marlowe@gmail.com>
To: Michelle Konzack <linux4michelle@tamay-dogan.net>
Cc: pgSQL - Admin <pgsql-admin@postgresql.org>
Subject: Re: How to setup tablespace and table partitioning in a template?
Date: Mon, 14 Jul 2008 12:10:46 -0600
Message-ID: <dcc563d10807141110l342cccb3y14c5729457fe7978@mail.gmail.com> (raw)
In-Reply-To: <20080712133752.GN24484@freenet.de>
References: <20080712133752.GN24484@freenet.de>
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.
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: scott.marlowe@gmail.com, linux4michelle@tamay-dogan.net
Subject: Re: How to setup tablespace and table partitioning in a template?
In-Reply-To: <dcc563d10807141110l342cccb3y14c5729457fe7978@mail.gmail.com>
* 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