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 _________________________________________________________________________________________ |