On Monday 23 December 2002 18:54, Tom Lane wrote:
Andreas Schmitz [EMAIL PROTECTED] writes:
I have a little problem with a database that is growing drastically. I am
getting short on diskspace within $PGDATA. Is there a way to use $PGDATA2
in addition to $PGDATA with the same database ?
There's no really practical way to do that at the moment within
Postgres. I'd recommend looking into OS-level facilities for spreading
a filesystem over multiple physical volumes --- depending on your
platform you might be able to do it with LVM, software RAID, etc.
regards, tom lane
Hi Tom,
thanks a lot for the answer. I considered using the raid functionality. My
problem is that I will loose days of work when I have to stop now. A $PGDATA2
ist known to the databaseserver. However, are there any plans for postgresql
to implement this feature ?
kind regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster