Question relating to database space and adding partition - Mailing list pgsql-admin

From Karthikeyan Sundaram
Subject Question relating to database space and adding partition
Date
Msg-id BAY131-F324B78FC3F8C804FF6260B0980@phx.gbl
Whole thread Raw
Responses Re: Question relating to database space and adding partition
how to add a new data partition
List pgsql-admin
Hi all,

   We are using postgres 8.0.1 on our production and 8.2 on our development.
  The linuix partition is getting full where the database resides.  In few
weeks our partition will ran out of space so the database will also run out
of space. We are added another partition of 300GB.  Now my question is, how
will I point the database to the new partition along with the old one.

   In oracle when we add a datafile, we can tell the location.  I don't know
how to do this in postgres.

   Can somebody help me?

Regards
skarthi

_________________________________________________________________
From predictions to trailers, check out the MSN Entertainment Guide to the
Academy Awards�
http://movies.msn.com/movies/oscars2007/?icid=ncoscartagline1


pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: destroyed db/index (corruption)
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Question relating to database space and adding partition