Re: dba and tables spaces questions

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
_________________________________________________________________________________________