Sergey Karin wrote:
Hi, List!
Lets suppose the next situation...
We create database cluster (via initdb) on some disk. Then we create and use
a database that can be very large. In some moment the database occupy all
disk space allicated to cluster.
The question is: are there any abilities in PostgreSQL to use for created
cluster additional disk space in new other disk? Similar ability exist in
Informix...
Well, there are various filesystem add-ons that allow you to have
virtual partitions spread over one or more physical disks. I'm guessing
you're not using any of those.
You can move the WAL to a different disk and use table-spaces to
relocate tables and indexes. See the manuals for tablespace setup and
check the mailing-list archives for how to do it the hard way with
symbolic links if you're running an old version of PG.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
