Skip site navigation (1) Skip section navigation (2)

Re: add space to expand database ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: a(dot)schmitz(at)cityweb(dot)de
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: add space to expand database ?
Date: 2002-12-23 17:54:55
Message-ID: 6596.1040666095@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Andreas SchmitzDate: 2002-12-23 17:56:45
Subject: Re: add space to expand database ?
Previous:From: Tom LaneDate: 2002-12-23 17:47:01
Subject: Re: not able to pg_dump the database...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group