pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddba and tables spaces questions
2+ messages / 2 participants
[nested] [flat]
* dba and tables spaces questions
@ 2008-12-08 22:20 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 1 reply; 2+ messages in thread
From: Isabella Ghiurea @ 2008-12-08 22:20 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: dba and tables spaces questions
@ 2008-12-09 05:48 Suresh Borse <s.borse@direction.biz>
parent: Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 0 replies; 2+ messages in thread
From: Suresh Borse @ 2008-12-09 05:48 UTC (permalink / raw)
To: isabella.ghiurea@nrc-cnrc.gc.ca; +Cc: 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
_________________________________________________________________________________________
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-12-09 05:48 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-08 22:20 dba and tables spaces questions Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2008-12-09 05:48 ` Suresh Borse <s.borse@direction.biz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox