From: | Suresh Borse <s(dot)borse(at)direction(dot)biz> |
---|---|
To: | isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: dba and tables spaces questions |
Date: | 2008-12-09 05:48:17 |
Message-ID: | 1228801697.2262.8.camel@dss-052.dsslp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
_________________________________________________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Rafael Domiciano | 2008-12-09 10:58:19 | Re: Vacuum Problems |
Previous Message | Scott Marlowe | 2008-12-08 23:36:31 | Re: recover or move databases |