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

Re: add space to expand database ?

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

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 a(dot)schmitz(at)cityweb(dot)de


In response to

Responses

pgsql-admin by date

Next:From: Bruce MomjianDate: 2002-12-23 17:56:46
Subject: Re: SSL Mode
Previous:From: Tom LaneDate: 2002-12-23 17:54:55
Subject: Re: add space to expand database ?

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