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