Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de> 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
In response to
pgsql-admin by date
|Next:||From: Andreas Schmitz||Date: 2002-12-23 17:56:45|
|Subject: Re: add space to expand database ?|
|Previous:||From: Tom Lane||Date: 2002-12-23 17:47:01|
|Subject: Re: not able to pg_dump the database... |