Обсуждение: dba and tables spaces questions

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

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 _________________________________________________________________________________________