dba and tables spaces questions

From: Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: dba and tables spaces questions
Date: 2008-12-08 22:20:35
Message-ID: 493D9DB3.3080202@nrc-cnrc.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message PJ 2008-12-08 23:27:07 recover or move databases
Previous Message Milen A. Radev 2008-12-08 21:06:52 Re: How can we see details of function in psql prompt