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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group