From: Suresh Borse <s.borse@direction.biz>
To: isabella.ghiurea@nrc-cnrc.gc.ca
Cc: pgsql-admin@postgresql.org
Subject: Re: dba and tables spaces questions
Date: Tue, 09 Dec 2008 11:18:17 +0530
Message-ID: <1228801697.2262.8.camel@dss-052.dsslp.com> (raw)
In-Reply-To: <493D9DB3.3080202@nrc-cnrc.gc.ca>
References: <493D9DB3.3080202@nrc-cnrc.gc.ca>
Hi,
you may try following.
You can create a one more table-space by using following command,
-- Tablespace: "tablespace - name "
-- DROP TABLESPACE tablespace_name
CREATE TABLESPACE tablespace_name
OWNER "UserName"
LOCATION 'path '; -- path for table-space
And move the existing object to other tablespace using following command
psql>ALTER TABLE table_name SET TABLESPACE tablespace_name;
Next, while adding new object take care of defining the tablespace name
also.
On Mon, 2008-12-08 at 14:20 -0800, Isabella Ghiurea wrote:
> Dear pg Gurus,
> I would like to know :
> 1- how can I alter an existing db on new table space, is there a cmd
> :alter db add tablespace2 etc ?
> 2- how can in create db allocate 2 -n tables spaces for a db ? " create
> db name with tablespace 1= .. and tablespace2=.... "will this be a
> valid cmd ? Or other solution to this issues ?
> using Pg version 8.3 on Linux
> Thank you in advance
> Isabella
>
>
>
Thanks & Regards,
Suresh Borse
(DBA)
_________________________________________________________________________________________
DIRECTION SOFTWARE SOLUTIONS
5, Brady Gladys Plaza, 1/447, Senapati Bapat Marg, Lower Parel, Mumbai -
400 013
Tel. : 91 22 66615000 (Ext: 350) Fax : 91 22
24911046
Cell : 91 9422 239338 Site :
www.direction.biz
_________________________________________________________________________________________
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: s.borse@direction.biz, isabella.ghiurea@nrc-cnrc.gc.ca
Subject: Re: dba and tables spaces questions
In-Reply-To: <1228801697.2262.8.camel@dss-052.dsslp.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