Re: [ADMIN] add space to expand database ?

2002-12-23 Thread Tom Lane 
Andreas Schmitz <[EMAIL PROTECTED]> writes:
> However, are there any plans for postgresql 
> to implement this feature ?

Tablespaces are on the TODO list, and may actually get done for 7.4.
But that isn't going to help you today...

regards, tom lane

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] add space to expand database ?

2002-12-23 Thread Andreas Schmitz 
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

Re: [ADMIN] add space to expand database ?

2002-12-23 Thread Tom Lane 
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

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org