From: Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
To: pgsql-admin@postgresql.org
Subject: dba and tables spaces questions
Date: Mon, 08 Dec 2008 14:20:35 -0800
Message-ID: <493D9DB3.3080202@nrc-cnrc.gc.ca> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: isabella.ghiurea@nrc-cnrc.gc.ca
Subject: Re: dba and tables spaces questions
In-Reply-To: <493D9DB3.3080202@nrc-cnrc.gc.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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