Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group