Karthikeyan Sundaram wrote: > 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? The easiest way would be to create a new tablespace: http://www.postgresql.org/docs/8.1/static/manage-ag-tablespaces.html > > Regards > skarthi > > _________________________________________________________________ > From predictions to trailers, check out the MSN Entertainment Guide to > the Academy Awards® > http://movies.msn.com/movies/oscars2007/?icid=ncoscartagline1 > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/
